Requestor is stored as a group record’s, you can find it in table
Groups, where the column Instance is the ticket id. And from the table
GroupMembers you can get this group’s member. Take a look at the example
Record in Groups:
| id | Name | Description | Domain | Type | Instance |
| 229203 | NULL | NULL | RT::Ticket-Role | Requestor | 56673 |
Respective record in GroupMembers:
| id | GroupId | MemberId |
| 129629 | 229203 | 186716 |
So you can get the GroupId from the Groups record by searching for
Instance=TicketId, and then from GroupMembers record you can get the
MemberId by searching for GroupId, then the MemberId is the user’s id in
Hope this helps.
[mailto:email@example.com] On Behalf Of
Sent: Friday, June 09, 2006 8:28 AM
Subject: [rt-users] where is the requestor stored?
I was wondering if anyone could tell me where in the database
the requestor is stored.
This is part of the perl script I am using to create the ticket:
my $CurrentUser = RT::Interface::CLI::GetCurrentUser();
my $ticket = new RT::Ticket($CurrentUser);
my $ticket_body = MIME::Entity->build(Data => "
This is a test ticket
Type => 'text/plain');
my %ticket_vals = ( Queue => 'Test',
Subject => 'Tetst',
Owner => 'Nobody',
Requestor => "test\@mydomain.com",
InitialPriority => '10',
FinalPriority => '25',
MIMEObj => $ticket_body,
my ($id, $transaction_object, $err) =
The ticket is created without a problem, I just need to know
where the requestor is being stored in the mysql database.
I have looked in the Tickets and Transactions tables, but it
does not appear to be in there.
Can anyone point me in the right direction?