Queries - Checking for Null in Where clause

[wings]

We want to add to the where clause of a custom queriy the following:

where (ObjectName.EndTo is NULL or ObjectName.EndTo >= CURRENT_DATE)

In the criterion there isn't an option checking for NULL and can we use CURRENT_DATE as a Value/Expression?

[bartthefish]

If your EndTo Attribute is a date or timestamp attribute using CURRENT_DATE should work.

Instead of NULL you can use UNDEFINED