[rt-users] Numeric custom field values

Parish, Brent bparish at cognex.com
Fri Jan 31 16:00:24 EST 2014

Sorry I forgot to add -

I'm not sure if the versions will make any difference in regards to this question, but I'm running RT 4.2.2 on Ubuntu 13.10 with MySQL 5.5.34 and Sphinx 2.1.3


From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Parish, Brent
Sent: Friday, January 31, 2014 2:52 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Numeric custom field values


I have some custom fields to track numeric priority independent of the built-in priority field.

This is an example of a search string I use:  Queue = 'helpdesk' AND 'CF.{Helpdesk Priority}' > 15
But this returns tickets where CF.{Helpdesk Priority} is set to 2
That leads me to believe that the operation being preformed is a string comparison (where 2 is indeed greater than 15), versus a numeric one.

So my question is:  is there a proper syntax to use in the search builder to treat those custom field values as numeric?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140131/0c8f522b/attachment.htm>

More information about the rt-users mailing list