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

[Ruslan Zakirov]

http://requesttracker.wikia.com/wiki/GetWatcherInfoByTicket

On Wed, Feb 9, 2011 at 5:27 PM, Tobias Hieta
<tobias.hieta at 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 at purplescout.se
> Cell: +46 732 051 411
> www: http://about.me/thieta
>
>



-- 
Best regards, Ruslan.