[rt-users] DB Query

[Forrest Blount]

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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com