[rt-users] Query Builder help

Barry Byrne barry.byrne at wbtsystems.com
Fri Oct 26 10:28:35 EDT 2007


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




More information about the rt-users mailing list