Displaying certain fields within filter/query

[Karen F. Schaefer]

I am attempting create a JQL filter that will show all Epics with their related stories and display the results as filter displaying specific fields.

How do I specify which fields should be displayed on the screen for the user? and how do I create the filter in JQL?

Thanks,

Karen

see attached 

[Mark Segall · Accepted solution]

If your goal is to present a hierarchical representation of epics/stories, you're not going to be able to accomplish this natively.  Filter results are going to be displayed one-dimensionally in tabular form.

Since you're on Jira Premium, you may want to instead leverage Advanced Roadmaps.  This will present a hierarchical presentation with several different ways to view the information.

[Karen F. Schaefer]

Thanks for your assistance, however I am new to JIRA what are advance roadmaps?

[Mark Segall]

In your menu bar, you'll see a link for Plans which are Advanced Roadmaps.  Here's a couple links to help you get started:

• Atlassian University
• Advanced Roadmaps Documentation

[Trudy Claspill · Accepted solution]

Hello @Karen F. Schaefer 

Welcome to the Atlassian community!

Are you working with issues in a Company Managed project or in a Team Managed project? The JQL will be different for each type of project. My answer applies to Company Managed projects.

Within the native Advanced Issue Search screen each row will display the information for only one issue. You may be able to create a filter that collects all the Epics and all their child stories, but you will not be able to display the parent Epic Name in a row that is displaying the details for a child story. Epic Name is a field that is specific to the Epic, and so would show a value only in the row displaying the information for that Epic.

If you want to filter for a specific set of Epics and their child issues, using native Jira functionality you would need to explicitly list the Epic keys thus:

issue in (<comma separated list of Epic issue keys>) or "Epic Link" in (<comma separated list of Epic issues keys>)

After getting the JQL set to retrieve the specified issues, you can change the Advanced Issue Search screen to display the output in List view.

After doing that you can select the Columns/Fields you want to display.

If you then Save that filter, and Share it with other users, they can run the filter and will see the same Columns/fields that you selected.

For more information on searching for issues and working with the results, refer to

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

If you have third party apps that extend searching and reporting capabilities, there may be more options to how to construct the search and present the results.