I am using JQL and Jira Cloud for Sheets to put some project info into a google sheet for specific tracking purposes. Part of the overall goal is to have a standard way to structure projects both in Jira and in the google sheet. My current experiment using this search string
(issuetype=Epic OR issuetype=Story) AND (labels = automation1.2 and labels = product_review) OR (labels = automation1.2 and labels = execute_commit) OR (labels = automation1.2 and labels = preliminary_project_proposal) OR (labels = automation1.2 and labels = delivery_commit) or (labels = automation1.2 and labels = production_commit) order by issuetype ASC, duedate ASC
Gets me close to what I want though it does not place the issues under the epic they relate to . I get a list of the epics and then a list of issues -- .
Epic1
Epic2
task1a
task1b
task2a
etc
Need to refine the search string so I get
Epic1
task1a
task1b
Epic2
task2a
task2b
All suggestions appreciated