I am using an Id as a data provider to show 2 fields in my valuelist. When users begin typing only the first 100 will be populated in the valuelist. I know the max is 500 but what can I do to reach maximum count. The scroll bar stops not allowing the user to see all options in the valuelist.
servoy 4.1.2
win xp sp3
Thanks
typeahead fields only shows you the first 100, type on to get to the result you want.
Why if you are already typing do you want to do scrolling? Just type on and you never have to scroll.
The field is defined as a text field with a valuelist. The value list is displaying 2 fields.The valuelist is returning and Id to the db and displaying 2 fields separated by a space. When I type values for any of the 2 fields in the valuelist the values start displaying in the value list as expected. However, a problem occurs when the first field value is repeated and the second value is different. When value one is repeated more than a 100 times it will not show the remaining possible choices for the valuelist. For example,if you were displaying a school in field 1 and students in field2 of the valuelist, the school would be repeated and the first 100 students would be displayed. If you knew the school, but were not sure of the student my valuelist would only display the first 100 students for that school. I need to be able to display all students for that school up to the max that servoy allows.
Servoy generates an or condition for you setup, so it does field1 like XXX or field2 like XXX
and if those are more then 100 servoy will not display more of them.
You can control that behavior a bit in 5 by using the a global method to fill your valuelist.
Then you are in control how the query is done and how much to return.