I assume you're looking at the ObjectCustomFieldValues table in the db?
This table contains both the ticket # (ObjectID), the custom field
(CustomField) and value (Content). You'll have to get the ID of the
custom field you're looking for from the CustomFields table.
Entries are only added to this table when CustomFieldValues have been
selected. Also make sure to look at the Disabled value for entries that
have been de-selected.
We use MySQL and RT 3.4.5, but I doubt this aspect of the schema has
changed.
John Paul Hayes wrote:
Hi All,
I am running a script with accesses the rtdb directly (for speed
purposes). One of the requirements is that I have to
find any ticket what was resolved with a custom field entry selected.
Does anybody know off hand how to link a ticket id to the custom field
entry id in the db?
Thanks in advance,
JP
--
"If you make people think they're thinking, they'll love you; but if
you really make them think they'll hate you."
— Don Marquis
------------------------------------------------------------------------
_______________________________________________
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
