On Fri, Sep 09, 2011 at 03:34:28PM +0100, Richard McMahon wrote: > 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.
As I believe I mentioned on #rt when you asked this question, the
TicketSQL parser only accepts a few operators on Date fields.
die "Invalid Date Op: $op"
unless $op =~ /^(=|>|<|>=|<=)$/;
If you read your logs, you should be seeing:
[Fri Sep 9 15:19:08 2011] [error]: Invalid Date Op: IS
You can file a feature request in the bug tracker:
http://bestpractical.com/rt/issues.html
-kevin
pgptptDGC0bkn.pgp
Description: PGP signature
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
