Hierarchy for Jira - Custom Issue Structure & Jira Tree View

It is possible to clone issue 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 issue 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 issues you want to clone (not only the parent issue)
In the Bulk Clone dialog under “Clone additional fields”
- Select “Issue Links”
- Select “Adjust issue links between issues part of this Bulk Clone”
- Deselect “Keep issue links to issues not part of this Bulk Clone”

Deep Clone for Jira Bulk Clone configuration screen with Target issue type and Issue links marked

Create a JQL Query of a Set of Issues 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 issues 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 issues 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 Issue 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 Issue 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 issues.

This simple method allows you to efficiently translate Issue Keys from your sheet into a valid JQL query for seamless integration with Jira.