Not null in related record?

[alb]

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)
}

[ROCLASI]

Hi alb,

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

Code: Select all

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

[alb]

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..........