Automation / Integration using JQL and Jira Cloud for Sheets - ordering tasks under epics

[Ellen Grace Henson]

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