Servoy 6.04 and Value Lists

Classic Servoy
1

Value Lists and the relative performance issues were discussed in this post:
viewtopic.php?f=16&t=17448

It appears that related value lists are a performance issue and I am needing to use them extensively to show real names based on Client IDs. An associated issue is I have 6500+ names and Servoy only finds 500 showing this error on load

Valuelist clients fully loaded with 500 rows, more rows are discarded!!

Is there a better way to manage this sort of approach other than value lists ?

I am restricting the amount of data shown to each user using a filter param, however need at some points to show them client names that are outside of their restricted list hence needing a reference to the external client ID - is there a way to do this ? for example pushing an extra item into the value list as you would on an array??? ideas very welcome ?

Hope everyone has a very happy and prosperous new year

ATB
Gordon

2

Hi Gordon,

First of all the notice is not an error. This is by design.
Also showing such a long list in a valuelist would be considered bad UI. With these long lists the motto should be: search, don’t browse.

What you want is a list picker, one where a user can search in this long list of items and select the one (or more!) based on the information shown in one or more columns.
I created the JSListpicker just for that purpose. It can handle millions of rows and is higly configurable.
Check it out at https://www.servoyforge.net/projects/mod-listpicker .

Hope this helps.

3

Robert

Thanks for your reply - this is not exactly what I was looking for, for this example, but is perfect for something else so great job and thanks for taking the time to create the plugin for ServoyForge.

best
Gordon