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