Relation with the "Is null" operator

Classic Servoy
1

Hello! This is probably a basic question, but, I didn’t find the answer.

Servoy 4.1.0; I want to create a relation that feeds a portal (permission records). I’m not expecting to use a Sql Query for this since this is a “built-in” feature.
One of the predicate involved in my relation, should be user_id equal to Null. When building relations, I think the “Is null” operator was there in previous Servoy versions (below the “Not Like”) !? Unfortunately, it doesn’t seems to be there anymore. So, how can I setup an “Is null” predicate ?

Thanks in advance for your thoughts.

2

Homer,

You can add a relation line from user_id to a global whose value is null.

Note that in release 4.2 we have extended the relation operators where it is possible to operators like ‘equals-or-null’

Rob

3

Thanks a lot Rob. Very helpful !