Thanks you both! On Tue, Aug 25, 2009 at 4:39 PM, Gaber Terseglav <[email protected]>wrote:
> select t1.id, t1.summary, t2.id > from ticket t1 > join agilo_link al on t1.id=al.src > join ticket t2 on al.dest=t2.id > where t1.type='requirement' and t2.type='story'; > > > On Mon, Aug 24, 2009 at 9:11 AM, Felix Schwarz > <[email protected]>wrote: > >> Am 23.08.2009 22:54, schrieb roman: >> >>> I'm a Trac/Agilo new user and I want to make a report to obtain all >>> the requirement for a story but I can't find the link between them. >>> Can anyone help me out with this? >>> >> >> The linking information is stored in the table agilo_link. You need to use >> some joins for that. >> >> fs >> >> > > > > -- Mario --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH http://www.agile42.com and is focused in supporting Agilo for Scrum users. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo?hl=en -~----------~----~----~----~------~----~------~--~---
