Hi all, Hoping someone can help me with a search I'm trying to build with Query Builder on v3.6.5.
Basically, I'm trying to find tickets where it's been more than a certain amount of time between the requester updating the ticket and someone other than the requestor updating the ticket. The two fields in Query Builder seem to be Told and Updated, but I can't seem to compare them. Is there some way to do something like: Find tickets where (Updated - Told) > 4 hours. Meaning it's been more than four hours since the requestor updated a ticket with no response. I've tried everything I can think of to no avail. Appreciate any help. Thanks, Barry _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. 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
