Where is the requestor stored?

RT Users
1

Hi,

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) = $ticket->Create(%ticket_vals);

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?

2

Hi Michael,

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
below.

  1. Record in Groups:
    | id | Name | Description | Domain | Type | Instance |
    | 229203 | NULL | NULL | RT::Ticket-Role | Requestor | 56673 |

  2. 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
Users table.

Hope this helps.

Regards,

David-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
michael@staff.esc.net.au
Sent: Friday, June 09, 2006 8:28 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] where is the requestor stored?

Hi,

 

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) =

$ticket->Create(%ticket_vals);

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?