Hi, I'm trying to use a SearchEngine against a datefield in an extratable. I want to find all rows where the datefield is NULL.
I've tried a few different variety of operators in my .addCriteria, but I'm unable to get it to search for NULL values.
Here is a simple example that doesn't work;
se.addCriteria("y_object.x_startdate", "OperatorIs", "", "OperatorAnd", 0);
How can I get it to build a SQL query that uses "x_startdate IS NULL" ?