JQL: I need to see, for each release, the stories and each stories tasks plus extra info

[Stephanie Beach]

I'm having trouble discovering which stories are really ready for testing in each sprint by the DoT.

I'd like to see something like this from a query:

Stories for release "MyRelease" have tasks;

                Story A with status of 'S'

                                Task-A in sprint 80 and status of ‘S’

                                Task-B in sprint 80 and status of ‘S’

                                Task-C in sprint 81 and status of ‘S’

                Story B with status of 'S'

                                Task-D in sprint 80 and status of ‘S’

                                Task-E in sprint 79 and status of ‘S’

                               ...

Where S can be "To Do", "In Progress", ...

Did anyone come up with a good grouping type query?

[Thomas Deiler]

Dear @Stephanie Beach,

JQL cannot really group the output. You can sort by any column but not how you described above.

Best you export to CSV and arrange the result, manually.

So long

Thomas

[Stephanie Beach]

OK thanks Thomas

I'll see about creating a query that can output each story and all linked issues in the list.

:)

[Thomas Deiler]

Dear @Stephanie Beach,

there is no built-in JQL function to return you the linked or child-Issues available. You have to make use of a 3rd party plugin.

But be careful when evaluating - there are some on the marketplace that can fulfill your needs. Finding the best one that also suits your budget is not easy. ;)

So long

Thomas

[Stephanie Beach]

That's easy: no budget. :)

Thanks again Thomas

I'll have to built up a series of queries and use some macros to get the data we need.