Query for all Stories and their Sub-Tasks in a specific project

[Gregory Kremer]

Hi Jira experts. I have a need to query for all Stories and Bugs, including all related sub-tasks in a specific project. I can use ScriptRunner to do so. Could someone please suggest a query for the Cloud version of Jira? I'd greatly appreciate it.

[Laurie Sciutti · Accepted solution]

Hi @Gregory Kremer ~ this should work (substituting for your projects, of course):

project in (A, B) AND issuetype in (Story, Bug) OR issueFunction in subtasksOf("project in (A, B) and issuetype in (Story, Bug)")

[Gregory Kremer]

@Laurie Sciutti Thank you very much. It worked great.

[Gregory Kremer]

Thank you