global relations that use calculated fields?

Classic Servoy
1

Hi,

I need to make a couple relationships for populating valuelists that key off of calculated fields. For example, I want a value list that shows all customers where enabled = 1.

The way I would do this is to create a oneKey calculated field that always returns 1, and use that to make the calculation. But I want to be able to use this relationship globally.

I would do this by generating a custom value list with a SQL query, but they don’t seem to work correctly with type ahead fields.

Any suggestions?

2

Instead of using a calculation, create a global integer and give it a default value of 1.