Query builder - Unable to search for NULL date fields


I’m trying to run a search that would return tickets that have not been
replied to yet (for which the Told field is NULL).

I’ve looked in the database, and the value of the field is NULL when a
ticket has not been replied to (not as a string, it actually is NULL)
and while I am able to pull tickets using a MySQL query, I am unable to
search for them using the query builder in RT 3.8.8.

Strangely enough, the following query is considered valid:
Queue = ‘’ and Told IS NULL

It returns tickets wether or not they have been replied to.

I guess what I am trying to achieve is the same thing as this:

The wiki was not helpful in regards to what I am trying to do:

Any ideas ?


  • David