Thank you, I guess I didn't search hard enough. I think 'Today' was not one of the various alternatives I used - I tried things like __CurrentDate__ and Now and GetDate and even SetToNow() - but this works great!
Again, thanks for the quick response for a newbie like me, AJ On Fri, Jul 16, 2010 at 12:50 PM, Roeing Corporation <[email protected]> wrote: > Looks like the query Due > 'Today' works. Just add Today in the Criteria list > in the query builder. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of AJ Ferrigno > Sent: Friday, July 16, 2010 12:44 PM > To: [email protected] > Subject: [rt-users] Query by Current Date > > Hello, I'm running RT 3.8.8 on Solaris 10 with Oracle 10g, > > I would like to create a saved search that shows me everything that I own > that is due after today (basically a to-do list of long-term items). I > understand how to do the first part (everything I own) by using > '__CurrentUser__' in the owner field. But how do I query based on the current > date? Can I use an equivalent string such as '__CurrentDate__'? This does not > work, nor do a number of possible alternatives (including sysdate). > > I looked in /lib/RT/Ticket_Overlay_SQL.pm (where grep told me __CurrentUser__ > is implemented) and I did not find another replace for any other variable. I > also cannot find anything by searching in the archives on this topic. Has > anyone else searched based on the current date who can give a quick answer? > Or would I have to use custom code to do this? If so, what should it be and > where should it go? > > Thanks in advance, > AJ > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
