[rt-users] Query by Current Date

[AJ Ferrigno]

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