[rt-users] Selecting data directly from RT db

[Gene LeDuc]

Hello Jose,

Custom field values are associated with the ticket number.

Table ObjectCustomFieldValues has 5 fields that are likely to be of 
interest to you:
   CustomField: has the id of the custom field (cross-ref to CustomFields:Id)
   ObjectType: you probably want this to be "RT::Ticket"
   ObjectId: this is the ticket id (cross-ref to Tickets::Id)
   Content: this has the value of the custom field if it is less than 256 
characters
   LargeContent: this has the value of the custom field if it's too big to 
fit in Content

There are other fields as well, but their exploration is left to the reader.

Regards,
Gene

At 01:57 PM 6/13/2007, José de Paula Eufrásio Júnior wrote:
>So, I'm doing a little python CGI that pulls data from the RT database, 
>but some things are a little off:
>
>* Sometimes counting the number of tickets 'new' and 'open' on a select 
>gives a slightly different value than doing the same thing on RT query 
>builder, like 3 or 4 tickets difference. Any tought why?
>
>* How I select custom fields from tickets? Are they associated with queue 
>or in other database?
>
>Thanks in advance for any help.
>
>[]s
>Jose P. E. Junior


-- 
Gene LeDuc, GSEC
Security Analyst
San Diego State University