[rt-users] Comparing field values in ticket sql

[Chris Herrmann]

Hi,

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?

Thanks,

Chris