Have you tried with lastupdated today ?
Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Klaus-Michael Kühne ________________________________ Von: [EMAIL PROTECTED] An: [email protected] Gesendet: Thu Aug 28 16:59:39 2008 Betreff: [rt-users] Using Functions in Query builder 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 [EMAIL PROTECTED] ketemaj on iChat
<<inline: kmail.png>>
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
