Valuelist Limitations

What ever happened to the request to make the max records in a valuelist developer determined? Is 500 records still the limit in 4.x? If so, this really is a limitation - I understand about the performance issue, but the 500 number is very arbitrary and I think too low, especially with simple code & description lookups. The alternative of coding a lookup is much more labor intensive. Also - is 500 the limit for a valuelist created with application.setValulistItems as well?

M.S.

Hi Mike,

I’m interested in the answer to that question too.
I don’t think a combobox with > 500 values constitutes a user friendly UI anymore but a typeahead field might be all you need to pick a customer from a list of customernames.
As far as I can see, Servoy 5rc1 still has this 500 limit.

Hi J.D.

I’m not sure why people say that a large valuelist is a poor UI. For example, in the medical industry there is a standard list of 1500 or so diagnosis codes . All they are is a code and a description. Most of the time the same few codes are used. There is no need for a sophisticated search or drill-down. What better way than a simple valuelist to validate the entry? Am I missing something?

Hi Mike,

I think it is because picking a value from a very long list (combobox) is timeconsuming. Scrolling your way down a list of 1500 codes is not very efficient.
Typeahead is a different matter. Now you efficiently type in the value and the system merely shows you the most likely canditate values. In the latter case, I fully agree on the need to support more than 500 values. My whole point is that I would never use a long list in combination with a combobox.

Agreed: combobox bad - type-ahead good.

Jeroen de Vries:
I think it is because picking a value from a very long list (combobox) is timeconsuming. Scrolling your way down a list of 1500 codes is not very efficient.

Correct, thats one of the reasons we limited to 500, also keep in mind the items have to be loaded as well (carried over the wire)

Jeroen de Vries:
Typeahead is a different matter. Now you efficiently type in the value and the system merely shows you the most likely canditate values. In the latter case, I fully agree on the need to support more than 500 values. My whole point is that I would never use a long list in combination with a combobox.

Typeahead popup has 500 items limit on list display, not on search/filter!

Actually the limit is on the valuelist (database/related) not on the GUI element, when you use application.setValulistItems(…) there is no limit, also the Servoy 5.0 new valuelist global method datasource has no limit.