Relation with a constant

Hello Everybody

I need a relation between 2 tables with a common field an a constant.

SQL would be:

… from tab1 join tab2 on tab1.xyz = tab2.xyz and tab2.xxx = ‘MYCONSTANT’

How to do this in Servoy
Best regards
Albert

Hi Albert,

Just define a global variable with a default value and use that global on the left side of your relationship definition.