Re: [rt-users] Numeric custom field values

2014-01-31 Thread Parish, Brent 
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

Thanks,
Brent



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

Hi.

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?

Thanks!
Brent

[rt-users] Numeric custom field values

2014-01-31 Thread Parish, Brent 
Hi.

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?

Thanks!
Brent