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,