Writing a group/sort filter or something that works!

Question

Limitations: I am using JIRA Core v7.6.8 (server); I do NOT have admin rights and no ability to add a plug-in.

I have combined filters using the 'filter =' function. Now, I would like to group by summary = epic link, then sort the grouping by issuetype (epic then work request/task), then sort each group by Release Responsible Date (oldest to newest). The desired result pattern of the query is below:

* Row 1: Epic A* Row 2: Child of/Issue in Epic A
* Row 3: Another Child of/Issue in Epic A

* Row 4: Epic B* Row 5: Child of/Issue in Epic B
* Row 6: Another Child of/Issue in Epic B
* Row 7: Another Child of/Issue in Epic B

* And so on and so on

Can anyone offer any assistance? If anyone can figure this out you are a genius in my book forever! Thank you all for your help. Remember my limitations listed above.

Fazila Ashraf · Answer

Hi @Apryl Harris

I dont think it is possible to achieve the desired result pattern with out additional plugin/admin access.

Check out the features of the Structure JIRA plugin https://marketplace.atlassian.com/apps/34717/structure-for-jira-projects-at-scale?hosting=server&tab=overview and discuss with your admin.

If no additional plugins is a very strong limitation, i would suggest you to explore this through direct db query (again your admin has to help on that) but understanding the jira tables and selecting the right stuff would be very very very difficult (for me)