Query for merged view of Issuetypes

[bravedj]

Dear Community,

Quick question:

We have Different issue types defined in a Project with Sub-Tasks under User Stories.

Is there a way to extract from Jira as below....

Epic.Key, User Story.Key, User Story.Description, User Story.Status, Sub-Task.Key, Sub-Task.Description, Sub-Task.Status

[bravedj]

Hi @Warren ,

continuation to above query, need some more help plz. I am trying to get the list of User Stories with "Sub-tasks status in (Done, Cancelled)". So it should pull only the count of User stories where the sub-tasks status in either Done or Cancelled.

am using below query, but doesn't pull anything.

project = JIRA AND "Epic Link" = JIRA-1 and issuetype = story and issueFunction in hasSubtasks() and (issueFunction in subtasksOf("status in (Done, Cancelled)"))

can you please help?

[bravedj]

sorry, wrong place.. ignore. Not table to delete it so creating new thread.

https://community.atlassian.com/t5/Jira-questions/Query-to-pull-User-Stories-with-Sub-tasks-status/qaq-p/1501170#M448123

[Warren]

Hi @bravedj 

You haven't said what method you're considering, so I'll list 2 here.

If you're able to use the API, then it is fairly easy. You would be able to find all User Stories within a particular Epic, then find all Sub-Tasks for each of those User Stories.

Doing it via a JQL query is somewhat more difficult - you could get all the User Stories for a particular Epic, but then you would need to manually find the Sub-Tasks for each User Story by changing the JQL each time - quite laborious.

Hope this helps

[bravedj]

Hi Warren,

Thanks for your response.  I am using JQL/Scriptrunner.

I am not sure how to use API for these kind of scenarios. any reference to these?

I will check with my developers also.

I could do in Excel but trying to find an easy way :)

[Warren]

Hi @bravedj 

Unfortunately I can't advise about ScriptRunner - I've never used it.

As for the REST API, it is really useful and powerful once you have it set up. If you have access to someone who can code, it is language independent (I had used Excel's VBA in the past, currently using C#) - the reference document for it is here. My answer in this post gives some C# code to get started

[bravedj]

Thank you, Let me look into it.