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

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110909/7ae30b0d/attachment.sig>