[rt-users] Comparing field values in ticket sql

[Kevin Falcone]

On Sun, Oct 21, 2012 at 10:40:57PM +1100, Chris Herrmann wrote:
> 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

TicketSQL does not support this.
You'll need to use the perl API to further limit.

-kevin

> -------------
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121022/f2363fc2/attachment.sig>