best way to filter valuelist

Classic Servoy
1

Very often I have a table for every valuelist and I have a integer (1/0) column “active” in this table.
If I want to create a valuelist of all the active=1 entries I do something like this:

sql= "SELECT ... WHERE active=1"
ds = databaseManager.getDataSetByQuery(...,sql,...)
r_real = ds.getColumnAsArray(1)
r_display = ds.getColumnAsArray(2)
application.setValueListItems('my_valuelist',r_display, r_real)

Is there not a best way?
Could be a feature request a filter dialog in the valuelist definition dialog?

2

Can also be achieved by creating a relation(may be global) with your desired condition setup(active=1) and use that relation in the valuelist. Isn’t it? Is it the best way? :wink:

3

Yes I know, but it’s not so pretty… if I have to filter a lot of valuelists with string values instead of 0/1 I have to create a lot of global variables and a lot of relations only for this?
For me not a so nice good practice…