Hello,
Attached to our tickets, we have a custom field called 'Reminder
Interval'. In this field, a number is written in minutes. I would like
to create a query that checks if the last update has been longer that
the amount of minutes in this field. I would think that that query would
look like this:
Status = 'open' AND 'CF.{Productomschrijving}' IS NOT 'NULL' AND
LastUpdated < 'CF.{Reminder Interval} minutes ago'
However, there is for example a ticket that has 15 in that custom field
and that hasn't been updated in 2 hours.
If I have the query:
Status = 'open' AND 'CF.{Productomschrijving}' IS NOT 'NULL' AND
LastUpdated < '15 minutes ago'
this gives back the 1 result.
However if I use the first query, no results are returned.
Am I using an incorrect syntax?
Thanks,
Alain
--
Met vriendelijke groet,
Claranet Benelux BV
Alain Sips
Software Ontwikkeling
_______________________________________________
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
