[rt-users] DB layout and getting the requestors for a ticket

[Gerard FENELON]

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