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 > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
