relation with null value

Classic Servoy
1

I built a relationship on two values:

organizationid = organizationid
globals.value = invoicesid

globals.value is in this case empty… (Is it really “” or is it null)

Now I don’t know if this is possible but what I try to archieve is find all orders in this case where the organizationid = organizationid and the invoicesid is still null (or empty).

How can I do this? What I defined above doesn’t work…

  1. organizationid = organizationid works…
  2. invoicesid = nullable…
2

the problem is that in youre case the global is “”
to set the global really to null you have to set it through javascript:

global.xxx = null;

then the related foundset should return the values where xxx is null …

3

Thanks Johan, it works now!!!