[rt-users] Need help with RT-SQL on days calculation

Kenneth Marshall ktm at rice.edu
Mon Sep 13 13:47:11 EDT 2010


On Mon, Sep 13, 2010 at 10:38:54AM -0700, Kenneth Crocker wrote:
> To list,
> 
> I've been to the wiki and did some googling but no joy. Most likely my
> inexperience with both.
> 
> I'm trying to run a query in RT that will give me all "open" tickets that
> are due within the next 30 days. Simple enough, but I can't seem to get the
> syntax right. I have:
> 
> (  Status != 'resolved' AND Status != 'rejected' ) AND Due < (today + 30
> days). I've tried variations of 'Today' and no joy.
> 
> Help please?
> 
> Thanks.
> 
> Kenn
> LBNL

What about something like:

Due < '30 days from now'
AND Due > 'today'

with the additional list of statuses?

Regards,
Ken



More information about the rt-users mailing list