More than 500 elements in the valuelist.

Classic Servoy
1

Hi All,

I require more than 500 elements in the valuelist . Is it not possible to have more than 500 elements in the valuelist dropdown ? . It is giving a message in the console :
“Valuelist requestors_all fully loaded with 500 rows, more rows are discarded!!” How can this be made possible ?.

Thanks in advance . Waiting for your feedback.

2

Use a type ahead field. Usually, value list with that many entries become very unhandy. A type ahead field is better suited for that amount of values.

3

Or use a lookup form in a dialogue window.
That’s what we use very often.
Also gives you the possibility to search first to narrow down the list and then select one.

4

Hi Patrick,

Thanks for your reply . I have made the field type ahead . But still getting the same issue . Because it is attached with the same value list . It is displaying the same message . Before the display type was combobox. I am not getting about the look up form . Actaually my dropdown is displayed in the dialog. I am using servoy 5.2.11.

5

For the type ahead you don’t need a value list. Just make the field a type ahead and set the value list to none.

6

Patrick,

For the type ahead you don’t need a value list. Just make the field a type ahead and set the value list to none.

How do you get the pick data in your field then ?

Regards,

7

i guess the valuelist is still being filled even when you use it as a typeahead.
So for a typeahead that warning can be ignored.

8

Hi Johan,

Thanks for your reply . But it is not allowing more than 500 elements . Even though I have made type . How to make it possible ? .

9

no it won’t load in more, but the typeahead when you filter will do that.
So it shouldn’t affect anything. Only if you would display that valuelist as a whole (for example in a Combox) then it will only show the first 500

10

Hi Johan,

Thanks for your reply . Eventhough I have made the field type ahead . How can I attach the data to the field ? . Is this not possible in servoy ? . Can’t we have more than 500 elements in the valuelist ?

Thanks in advance . Waiting for you feedback.

11

Hi Ashutos,

Perhaps you want to look at the JSListpicker.
It can handle (way) more than 500 elements.

Hope this helps.

12

ashutos:
Hi Johan,

Thanks for your reply . Eventhough I have made the field type ahead . How can I attach the data to the field ? . Is this not possible in servoy ? . Can’t we have more than 500 elements in the valuelist ?

Thanks in advance . Waiting for you feedback.

With a type ahead it doesn’t matter, you can ignore the 500 because it will only show the top 100 or do at once. Depending on the data you type, so you’re filter. But it will show everything, not just at once