[rt-users] search for tickets with Date or Told Not set

Richard McMahon rgm at ast.cam.ac.uk
Fri Sep 9 10:34:28 EDT 2011


Hello,

I would like to search for tickets with Last Contact: Not
set. i.e Told = 'Not set' or Told IS NULL in the query builder.

Neither of the above return any tickets. This is an issues in RT 3.8 and I 
can reproduce the issues with the demo sites that run 4.0 and 4.2.

The issue is part of specific query which is intended to check for
tickets which have not had requestor contact for a week.

i.e. Told < '-7 days'

The above does not return the ticket where there has been no
contact with the requestor by the owner since Last Contact: Not set

I have searched this list, wiki and google without success.

Thanks Richard



More information about the rt-users mailing list