[rt-users] Comparing field values in ticket sql

Chris Herrmann chrisherrmann7 at gmail.com
Sun Oct 21 07:40:57 EDT 2012


Is it possible to compare field values in ticket sql? For example,
something like:

( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) AND
TimeWorked > TimeEstimated

If I use something like: "TimeWorked > 60", or "TimeEstimated > 100"
then I get the results I expect - but what I want to do is find
tickets based upon conditions like:

TimeWorked > TimeEstimated
TimeWorked > (TimeEstimated*0.8) #e.g. 80% of estimated time

and so forth

Is this possible?



More information about the rt-users mailing list