[rt-users] Using Functions in Query builder

[Ketema Harris]

Hi, I was wondering if it were possible to use functions in the search  
query builder.  For example I built a very simply search in the  
builder that looks for tickets that have not been updated since a  
certain time.  The "SQL" generated in the advanced window is :

  Status != 'resolved' AND LastUpdated < '8/28/2008'

i would like that date to be able to be replaced by the function  
now().  I use PostgreSQL as the backend.

Thanks





Ketema J. Harris
www.ketema.net
ketema at ketema.net
ketemaj on iChat


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080828/0e7a8bd2/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kmail.png
Type: image/png
Size: 1690 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080828/0e7a8bd2/attachment.png>