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
pgpCsQ2bf4yts.pgp
Description: PGP signature
-------- Final RT training for 2012 in Atlanta, GA - October 23 & 24 http://bestpractical.com/training We're hiring! http://bestpractical.com/jobs
