On 6 Aug, 2009, at 18:36 , Dr Josef Karthauser wrote:

> On 6 Aug 2009, at 17:25, Ash wrote:
>
>> I was just wondering if anyone had any good reports that they could
>> recommend that would compliment the new features added by Agilo, such
>> as maybe 'Tasks without a Story' or anything useful really.
>>
>> Anyone?
>
> I'd be interested in that one (or at least 'Stories' without a
> requirement). I couldn't work out how to do it with the new reporting
> system, as it requires a lookup through the link table. Can I do it
> without resorting to SQL?

To really get the linked ones, or the not linked ones require SQL JOIN  
with the agilo_links table, on the other hand, not all the tasks with  
no story are negative, or suspect. We have a report - that can be done  
using the Custom Query - to get all the task without an explicit  
"Sprint" planned, that would pop up all the tasks (also linked to  
stories) that are possibly lost in between sprints, the same can be  
done with stories...

e.g:  
status 
= 
accepted 
&status 
= 
assigned 
&status 
= 
new 
&status 
=reopened&order=priority&col=id&col=summary&col=status&sprint=&type=task

HTH
ANdreaT

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

Reply via email to