Gene LeDuc wrote:
Hello Jose,
Custom field values are associated with the ticket number.
I did the magic with custom fields and some joins, but there's something
bugging me now: where RT stores the information about the 'Requestor' of
a ticket?
[]s
core
: Re: [rt-users] Selecting data directly from RT db
Gene LeDuc wrote:
Hello Jose,
Custom field values are associated with the ticket number.
I did the magic with custom fields and some joins, but there's something
bugging me now: where RT stores the information about the 'Requestor
At Monday 6/18/2007 03:47 PM, you wrote:
In the DB, Tickets.Creator should be the requestor. This is a
reference to Users.id.
-Sean
No, Creator is the person who created the ticket. If you create a
ticket in the web interface and specify someone else as the
requestor, you are the creator.
Jeff Platter wrote:
There should be a creator integer field on the tickets table. That integer
associates with a user id for the requestor.
Sometimes people from the helpdesk get a call and create the ticket,
making the helpdesk person the creator.
The strange thing is on RT interface the
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
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