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

[Tobias Hieta]

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 at purplescout.se
Cell: +46 732 051 411
www: http://about.me/thieta