Referring to CustomField by ID in TicketSQL

RT Users
1

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,

2

Try giving those two Custom fields some sort of identifier, like a prefix
or suffix. Might help.

KennOn Tue, Dec 11, 2012 at 5:42 PM, John Kelsh jkelsh@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 distinguish between two identically named custom
fields.

Thanks,

We’re hiring! Careers — Best Practical Solutions

3

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 two CFs are
applied to different queues, you can also use the syntax:
‘CF.QueueName.{CF Name}’

4

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 trs@bestpractical.com wrote:

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 two CFs are
applied to different queues, you can also use the syntax:
‘CF.QueueName.{CF Name}’

We’re hiring! Careers — Best Practical Solutions

5

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} has been supported since RT 3.8.3. What version are
you using?