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
_______________________________________________
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
