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

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?
Search harder / check the wiki. RT groks expressions like ‘2 days ago’
or ‘-2 days’

Cambridge Energy Alliance: Save money. Save the planet.

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,
AJOn Fri, Jul 16, 2010 at 12:50 PM, Roeing Corporation roeing@areafive.com wrote:

Looks like the query Due > ‘Today’ works. Just add Today in the Criteria list in the query builder.

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of AJ Ferrigno
Sent: Friday, July 16, 2010 12:44 PM
To: rt-users@lists.bestpractical.com
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