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

Question

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?

Stephanie Beach · Answer

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.

Thomas Deiler_db00h3 · Answer

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 · Answer

OK thanks Thomas

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

:)