[rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread John Kelsh
Hi All, Is this possible? i.e. can a custom field value be selected by custom field id? I want to use this to distinguish between two identically named custom fields. Thanks, We're hiring! http://bestpractical.com/jobs

Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Kenneth Crocker
Try giving those two Custom fields some sort of identifier, like a prefix or suffix. Might help. Kenn On Tue, Dec 11, 2012 at 5:42 PM, John Kelsh jke...@netspot.com.au wrote: Hi All, Is this possible? i.e. can a custom field value be selected by custom field id? I want to use this to

Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Thomas Sibley
On 12/11/2012 05:42 PM, John Kelsh wrote: Hi All, Is this possible? i.e. can a custom field value be selected by custom field id? I want to use this to distinguish between two identically named custom fields. Have you tried it? CF.42 = 'foo' works just fine. So does 'CF.{42}'. If your

Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread John Kelsh
Hi Thomas, Thanks for the information. I tried the obvious combinations, including the formats you suggested. Do you know when this feature was introduced? I'm working on an older version of RT so it may not be implemented? Thanks, On 12/12/2012, at 1:49 PM, Thomas Sibley

Re: [rt-users] Referring to CustomField by ID in TicketSQL

2012-12-11 Thread Thomas Sibley
On 12/11/2012 09:11 PM, John Kelsh wrote: Hi Thomas, Thanks for the information. I tried the obvious combinations, including the formats you suggested. Do you know when this feature was introduced? I'm working on an older version of RT so it may not be implemented? I believe CF.{42}