Value Lists

Classic Servoy
1

My value list has about 2500 records. How can I implement ‘text as you type’ or auto highlight the account name in the listing as text is inputed?

Thanks

2

for such an amout of values you should implement a search dialog so that users can search for a specific record.

filtering a list when typing keys is not done possible right now.
We are thinking of given developers keytyped event but using that for a search criteria is not really a good idee for the application (fires much to many searches over the line)

3

It is easy to implement a “version” of text as you type. For many of my list views I put a global field at the top of a column. A user types in the global field and hits enter to perform the find. The onAction event of the field runs a method that performs the find then puts the cursor right back into the global field at the end of the text.

The only difference is that the user has to hit return to trigger the search.

  • David
4

Any field that has a value list be it custom or related, when you are typing in text, the field’s behavior should autocomplete to the closest matched value in the list. There is no overhead in doing this, and no SQL queries should need to be executed past the first one that gets the related valuelist.

The portion of the field that was autofilled should always be highligted so that while the user keeps typing it overwrites the suggested completion.

The only trick is that the auto fill should not happen when the user presses the enter, tab, del or bkspc keys.

No need for a onkeystroke trigger. This should be default behavior for all fields with valuelists

5

in 2.1beta you now have a TYPE_AHEAD field type.

If you don’t attach a valuelist to it it will lookup all the possible entries from the column it is build on. It only looks up when you have typed the first letter (and then to a max of 100 so when there are more you have to type the second letter first to really get the one you want)

Wehn you attach a value list to it. It goes through the valuelist. So if you have a product_id column in a table as fk. And that points to a product in the product table. Then you can select a product fast now with by typing its name if you have a relation that has the id as return value and the name as its display value.

If you give a TEXT_FIELD a valuelist then under water it will generate the same thing as a TYPE_AHEAD field (with a valuelist). So if you have solution now build by 2.0 with valuelist attached to TEXT_FIELDS it will now be type aheads.