Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to merge two scrum boards using jql

soniaarora
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 4, 2022

 

project = HMP AND (component != NIC OR component is EMPTY) AND issuetype not in (Initiative) ORDER BY Rank ASC

 

project = HMP AND component = NIC AND issuetype not in (Initiative) ORDER BY Rank ASC

1 answer

2 votes
Jack Brickey
Community Champion
March 4, 2022

If you  are  asking how to merge those two JQL queries into one such that it  results in the summation of both then it seems to me that the following JQL would achieve the goal.

project = HMP AND issuetype != Initiative ORDER BY Rank ASC

soniaarora
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 6, 2022 edited

Thank you. So i have two scrum boards and was asked to merge them into one. 
i copied jql from board 1 and jql from board 2. I created a new scrum board but when i copy paste both jql, it gives me error and does not show me data from both boards. The query i posted above are the two queries for two boards

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2022

Copying JQL is not going to help you.  You need to create a new query that selects everything you want to see on the new board.

Look more closely at the two queries, they look to me that they are directly conflicting (component = NIC and component != NIC is going to exclude every issue that has a component set).

You need to create a query that will select everything that you want to see on the new ("merged") board, and without knowing what you're trying to do, all we can tell you is that the JQL Jack gave you is probably the JQL you need.

Like • Jack Brickey likes this
Jack Brickey
Community Champion
March 7, 2022

+1 for Nic's reply... you don't "merges" two boards you create a new board that captures the issues of the current two boards.

Like • Nic Brough -Adaptavist- likes this

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, aafp, jira migration, marketing collaboration, end siloed work, streamline workflows, kerrie gottschalk, jira cloud admins, unified marketing, process visibility, team efficiency, cross-team collaboration

How Kerrie Gottschalk unified AAFP’s marketing team with Jira

At the American Academy of Family Physicians, siloed marketing teams faced delays and duplicate work. Kerrie Gottschalk shook things up by moving the department to Jira, streamlining processes, boosting visibility, and sparking stronger collaboration.

Read the story
AUG Leaders

Atlassian Community Events