[rt-users] CustomFieldValues vs ObjectCustomFieldValues

[Matthew Keller]

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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com