CustomFieldValues vs ObjectCustomFieldValues

RT Users
1

According to the RT book, CustomFieldValues holds the list of acceptable vaules
for Select custom fields while ObjectCustomFieldValues holds all custom field
values for all tickets.

So if I only want to pull the values from one CF I would use CustomFieldValues
and if I want to get all possible options I would use ObjectCustomFieldValues?

Mathew

2

ObjectCustomFieldValues table holds the actual values for the ticket, as
you said. So if you want to see what someone SET a value to, for a
ticket, you want to check the CustomField, which will be the ‘id’ of the
field… and Content, which is the value someone set. The ‘ObjectId’ in
that table, refers to a transaction… from there you can back up to a
ticket, etc.

CustomFieldValues holds the possible values for the “select” boxes of
various types, and I don’t think that’s what you’re looking for.On Fri, 2007-01-12 at 02:24 -0500, Mathew Snyder wrote:

According to the RT book, CustomFieldValues holds the list of acceptable vaules
for Select custom fields while ObjectCustomFieldValues holds all custom field
values for all tickets.

So if I only want to pull the values from one CF I would use CustomFieldValues
and if I want to get all possible options I would use ObjectCustomFieldValues?

Mathew

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

3

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Mathew Snyder
Sent: Friday, January 12, 2007 2:25 AM
To: RT Users
Subject: [rt-users] CustomFieldValues vs ObjectCustomFieldValues

According to the RT book, CustomFieldValues holds the list of
acceptable vaules
for Select custom fields while ObjectCustomFieldValues holds
all custom field
values for all tickets.

So if I only want to pull the values from one CF I would use
CustomFieldValues
and if I want to get all possible options I would use
ObjectCustomFieldValues?

Mathew

Not quite - CustomFieldValues has the list of values you defined for a
select CF. ObjectCustomFieldValues has the values for a CF that have been
chosen for a ticket (object, really).

So if you have a ‘select one value’ custom field called Platform, and you’ve
defined ‘Mac’, ‘Windows’ and ‘Linux’ as values for the CF, you would see
these three values in CustomFieldValues.

And if you set this CF on ticket 100 to be ‘Mac’ and on ticket 200 to be
‘Linux’, you’d see two entries in ObjectCustomFieldValues, one saying that
ticket 100’s value for Platform is ‘Mac’, and the other saying that ticket
200’s value for Platform is ‘Linux’.

Steve