Query for merged view of Issuetypes

Question

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

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

bravedj · Answer

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

Thank you, Let me look into it.