Not null in related record?

Classic Servoy
1

I have two tables master & history which have a relationship.
I need to do a find for all records in master where the date_left columns is NOT NULL.
Can’t seem to get the syntax correct, both for the not null and the related column.

This is the function attached to the master form that doesnt work :(

function activeOnly()
controller.find()
date_left = ‘^’ ← how do I specify ‘where history.date_left’ is NOT NULL’
controller.search(true,false)
}

2

Hi alb,

In Servoy you use the exclamation point for ‘NOT’.
So your code looks like this

function activeOnly()
{
   controller.find();
   date_left = '!^';
   controller.search(true,false);
}
3

Thanks thats great. I also worked out that to search in a related record all I need to do is prefix the relationship so the code becomes:

function activeOnly()
{
controller.find()
member_to_history.date_left = ‘!^’
controller.search(true,false)
}

Too easy :)
Spent too many years coding SQL directly…