DB layout and getting the requestors for a ticket

RT Users
1

Hello,

First of all I would like to say: I know this is not the best way to do it, I know the underlying database will probably change and my non-warranty is even more void. BUT, I would like to select requestors and owner etc from a ticket directly on the database (I am using MySQL), I have tried to figure out how to get the requestor from the tables by looking at the schema and the code, but it eludes me. Can someone point me in the right direction on how to make a direct select statement to get this information?

Thanks,
Tobias

Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hieta@purplescout.se
Cell: +46 732 051 411
www: Tobias Hieta | about.me

2

Tobias

Something similar to

FROM         Tickets                 AS Ticket
        JOIN Groups                  AS ReqGroup       ON

ReqGroup.instance = Ticket.id
JOIN GroupMembers AS ReqGroupMember ON
ReqGroupMember.GroupId = ReqGroup.id
JOIN Users AS Requestor ON
ReqGroupMember.MemberId = Requestor.id

should do the trick

GerardOn 2011-02-09 11:19, Tobias Hieta wrote:

Hello,

First of all I would like to say: I know this is not the best way to do it, I know the underlying database will probably change and my non-warranty is even more void. BUT, I would like to select requestors and owner etc from a ticket directly on the database (I am using MySQL), I have tried to figure out how to get the requestor from the tables by looking at the schema and the code, but it eludes me. Can someone point me in the right direction on how to make a direct select statement to get this information?

Thanks,
Tobias

Gerard FENELON Corporate Support
Emulation& Verification Engineering
2 bis, voie La Cardon
phone: +33 1 6453 2734 Parc Gutenberg
fax: +33 1 6453 2740 91120 Palaiseau
http://www.eve-team.com FRANCE

3

Thanks Gerard,

I will try that at once.

– Tobias----- Original Message -----

Tobias

Something similar to

FROM Tickets AS Ticket
JOIN Groups AS ReqGroup ON
ReqGroup.instance = Ticket.id
JOIN GroupMembers AS ReqGroupMember ON
ReqGroupMember.GroupId = ReqGroup.id
JOIN Users AS Requestor ON
ReqGroupMember.MemberId = Requestor.id

should do the trick

Gerard

On 2011-02-09 11:19, Tobias Hieta wrote:

Hello,

First of all I would like to say: I know this is not the best way to
do it, I know the underlying database will probably change and my
non-warranty is even more void. BUT, I would like to select
requestors and owner etc from a ticket directly on the database (I
am using MySQL), I have tried to figure out how to get the requestor
from the tables by looking at the schema and the code, but it eludes
me. Can someone point me in the right direction on how to make a
direct select statement to get this information?

Thanks,
Tobias

–
Gerard FENELON Corporate Support
Emulation& Verification Engineering
2 bis, voie La Cardon
phone: +33 1 6453 2734 Parc Gutenberg
fax: +33 1 6453 2740 91120 Palaiseau
http://www.eve-team.com FRANCE

Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hieta@purplescout.se
Cell: +46 732 051 411
www: Tobias Hieta | about.me

4

http://requesttracker.wikia.com/wiki/GetWatcherInfoByTicketOn Wed, Feb 9, 2011 at 5:27 PM, Tobias Hieta tobias.hieta@purplescout.se wrote:

Thanks Gerard,

I will try that at once.

– Tobias

----- Original Message -----

Tobias

Something similar to

FROM Tickets AS Ticket
JOIN Groups AS ReqGroup ON
ReqGroup.instance = Ticket.id
JOIN GroupMembers AS ReqGroupMember ON
ReqGroupMember.GroupId = ReqGroup.id
JOIN Users AS Requestor ON
ReqGroupMember.MemberId = Requestor.id

should do the trick

Gerard

On 2011-02-09 11:19, Tobias Hieta wrote:

Hello,

First of all I would like to say: I know this is not the best way to
do it, I know the underlying database will probably change and my
non-warranty is even more void. BUT, I would like to select
requestors and owner etc from a ticket directly on the database (I
am using MySQL), I have tried to figure out how to get the requestor
from the tables by looking at the schema and the code, but it eludes
me. Can someone point me in the right direction on how to make a
direct select statement to get this information?

Thanks,
Tobias

–
Gerard FENELON Corporate Support
Emulation& Verification Engineering
2 bis, voie La Cardon
phone: +33 1 6453 2734 Parc Gutenberg
fax: +33 1 6453 2740 91120 Palaiseau
http://www.eve-team.com FRANCE

–
Tobias Hieta
Project Manager @ Purple Scout
E-Mail: tobias.hieta@purplescout.se
Cell: +46 732 051 411
www: Tobias Hieta | about.me

Best regards, Ruslan.