Hierarchy for Jira - Custom Issue Structure & Jira Tree View
It is possible to clone work item hierarchies created with “Hierarchy for Jira” from Adaptavist.
Hierarchy for Jira displays
Jira standard hierarchies (e.g., Epic - Story - Subtask)
Custom hierarchies created with “Hierarchy for Jira”
Clone Jira Standard Hierarchy
If you want to clone a standard hierarchy (e.g., Epic - Story - Subtask), simply follow the documentation for Epic/Tree Clone.
Clone “Hierarchy for Jira” Custom Hierarchy
These custom hierarchies make use of Jira work item links. Therefore, you need to work with Bulk Clone, not Epic/Tree Clone.
Follow the Bulk Clone instructions and keep the following in mind:
Select all work items you want to clone (not only the parent work item)
In the Bulk Clone dialog under “Clone additional fields”
Select “Work Item Links”
Select “Adjust work item links between work items part of this Bulk Clone”
Deselect “Keep work item links to work items not part of this Bulk Clone”
Create a JQL Query of a Set of Work Items Filtered With Hierarchy for Jira Using LibreOffice Calc or Google Sheets
In some situations, it might be tricky to create the correct JQL for all work items you want to Bulk Clone. You can use this workaround to create your custom JQL from the Hierarchy for Jira view.
Navigate to Apps > Hierarchy for Jira
Filter for the work items you want to Bulk Clone
Click on Export Icon > Export to CSV on the top right
The CSV file is downloaded
Open the CSV file with LibreOffice Calc/Google Sheets
Select a cell in which you want the generated JQL query to appear
Enter the following formula, assuming your Work Item Keys are in column B from B3 to B100 (adjust the range based on your data):
="issuekey in (" & TEXTJOIN(", ", TRUE, B3:B100) & ")"
This formula uses TEXTJOIN to concatenate the Work Item Keys with commas as separators.
Press Enter
Hit the Enter key to execute the formula. The cell will now display the generated JQL query.
Copy the JQL Query
Copy the generated JQL query from the cell. It should look like:
issuekey in (KEY-55, KEY-54, KEY-53, ..., KEY-103)
Now you can paste the JQL query directly into your Jira search or filter to retrieve the desired set of work items.
This simple method allows you to efficiently translate Work Item Keys from your sheet into a valid JQL query for seamless integration with Jira.
