DB layout and getting the requestors for a ticket

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: http://about.me/thieta

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

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: http://about.me/thieta

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: http://about.me/thieta

Best regards, Ruslan.