How to use a Jira board name in JQL

Parto Hamidi November 15, 2024

Hi All,

I have 2 boards in a project. I want to have each board just showing the Epics and Tasks related to that board. One of the boards name is: Data Migration

I used the below JQL:

project = AOPS AND "Board name" = "Data Migration" 

it returns the error "Board name" doesn't exist.

Will be appreciated if you could help me

2 answers

2 accepted

4 votes
Answer accepted
Danut M _StonikByte_
Atlassian Partner
November 16, 2024

Hi @Parto Hamidi,

You cannot use the board name in JQL filters. 

But, you can use the board's filter name in your JQL, which produces exactly the  results that you expect. 

Here is how:

  1. Identify the filter of your Data Migration board, from Board Configuration > General tab  image.png
  2. Then update your JQL to use the filter, instead board name

Assuming that your board's filter is "Filter for Data Migration board", your JQL will be:

project = AOPS and filter = "Filter for Data Migration board"

 

Danut.

0 votes
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 15, 2024

Hello @Parto Hamidi  

"Board name" is a field in Jira issues, which is why you got the error message.

Boards show issues based on a filter. The filter uses data elements available in issues to select those issues.

Since boards use filters to select issues, and filters can select issues based on any number of criteria, a given issue can appear in multiple boards because it matches their filters.

You need to have some piece of data in each issue that can be used by a filter to determine the board on which you want that issue displayed. As examples, you could use

- a Label value
Labels = DataMigration

- the fact that the Assignee is a member of a particular user group
assignee in membersOf("yourUserGroup")

- a keyword existing in the issue summary
summary ~ "keyword for Data Migration board"

There are an endless variety of options you could use.

When you have the field value set for each issue, then you can modify the filter used by each board to select issues based on that field's value.

Parto Hamidi November 18, 2024

Thank you!

Will be appreciated if you could help me with this question as well:

How can I sort a board based on the Epics name (Alphabetic sort) or Epic Link?

Thank you

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 18, 2024

Hello @Parto Hamidi 

In the future please use the Ask the community option to start a new post for a new question, rather than adding an unrelated question to an existing post.

Issues are sorted on boards by their Rank, which allow us you change the relative priority of an issue by dragging the issue higher or lower in the issue list displays. The ordering/sorting of the issues is specified within the Filter that is used by the board; i.e. 

ORDER BY Rank DESC

If you change the ORDER BY clause then you will break the ability to drag and drop issues up and down the list.

On boards you can use the Group By or Swimlane option to set up horizontal groupings of the issues based on their parent Epic.

Screenshot 2024-11-18 at 12.45.56 PM.png

The ordering of the Epics and the child issues shown under each Epic will still be based on RANK unless you change the ORDER BY clause of the board filter.

 

If you want to explore this topic in more detail or have more question, please start a new Question post.

Parto Hamidi November 18, 2024

Thank you so much!

Like Trudy Claspill likes this

Suggest an answer

Log in or Sign up to answer