RobertoR | 11 Sep 2012 20:01
Picon

[Trac] Report to show User Stories and associated tasks

Hello all !
I need to create a query just like the Sprint Backlog, that shows, indented, the requirements, then the corresponding User Story, and then the corresponding tasks.
Now, I understand all those are different entries in the Ticket table, but I could not find how to relate them logically, through the ID, or through any other field.
Could you give me some directions ?
 
I checked the database schema available in the following link
 
 
 
Is there a way I can generate that report without adding any plugin, and just using the information available on the existing tables ?
 
I'm using TRAC version 0.11.
 
Thank you a lot in advance !
Best regards.
Roberto.

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/Ki1sX3tUAlYJ.
To post to this group, send email to trac-users-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to trac-users+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Steffen Hoffmann | 12 Sep 2012 00:00
Picon

Re: [Trac] Report to show User Stories and associated tasks


On 11.09.2012 20:01, RobertoR wrote:
> Hello all !
> I need to create a query just like the Sprint Backlog, that shows,
> indented, the requirements, then the corresponding User Story, and then
> the corresponding tasks.

You're speaking about a presentation like in /project view:
= Milestone
description containing

== Requirements
 *
 *

== User Story
Just text

[=======|=================]
progress bar with ticket refs

optional ticket list provided by TicketQuery macro

or does these terms have a different meaning to you? At least they've
not been neither coined nor used extensively in Trac context.

> Now, I understand all those are different entries in the Ticket table,
> but I could not find how to relate them logically, through the ID, or
> through any other field.
> Could you give me some directions ?

Depends on your response to clarify your questions according to my
request above.

Steffen Hoffmann
RjOllos | 1 Oct 2012 21:56

[Trac] Re: Report to show User Stories and associated tasks

On Tuesday, September 11, 2012 11:01:08 AM UTC-7, RobertoR wrote:

I need to create a query just like the Sprint Backlog, that shows, indented, the requirements, then the corresponding User Story, and then the corresponding tasks.
Now, I understand all those are different entries in the Ticket table, but I could not find how to relate them logically, through the ID, or through any other field.
Could you give me some directions ?

I suspect you are using AgiloTrac or similar. Could you clarify?
 
 

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/ivOPE3Dy_gEJ.
To post to this group, send email to trac-users-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to trac-users+unsubscribe <at> googlegroups.com.
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.

Gmane