http://requesttracker.wikia.com/wiki/GetWatcherInfoByTicket
On Wed, Feb 9, 2011 at 5:27 PM, Tobias Hieta <[email protected]> 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: [email protected] > Cell: +46 732 051 411 > www: http://about.me/thieta > > -- Best regards, Ruslan.
