JQL Question - Sharing Field Values Across Hierarchy Levels

[Tim Comella]

Hi, All,

Could use some guidance on approach to leverage JQL (no added plugins) to share values across hierarchy levels.  Simplified use case:

1) Two levels in the hierarchy lets call them:

             Theme level - has fields for Issue and Issue_Summary - this is the parent level

                   Initiative level - this is the child level

2) Would like to write JQL to export data in the Initiative level but additionally, pull in the Issue and Issue_Summary content that reside in the parent Theme level.  Is there a workable approach to doing this?

[Ojase Emmanuval · Accepted solution]

@Tim Comella Please Export the Parent link column also in your export and use those keys to run a separate search if you want to export child and parent issues. 

[Trudy Claspill · Accepted solution]

Hello @Tim Comella 

JQL is a method for selecting a set of issues. JQL output will give you only data from the issues you retrieve. If you retrieve only Initiative issues and those issues don't include data copied from the Theme, then you won't have access to the data that is only in the related Themes.

Depending on your deployment type (server or data center) and the version of your Jira product you might have access to (or be able to get access to) the free Automation for Jira plugin. That plugin could enable you to automatically copy information from a parent Theme to a child Initiative, and then you would be able to present that Theme information as part of the output of the retrieved child Initiatives.

You could also potentially look at a solution using the API to retrieve the Initiatives, then retrieve the related Themes, and cobble together the output of the two data sets.

[Tim Comella]

Thank you!  :-)   Will look into the automation plugins you have suggested.