is there a JQL query to select the Board

[Niraj Shakya]

I require a JQL query where to select a Project and select a board and opensprint() where updates made in the issues on the current sprint board.

I am not able to select the board.

My company has created multiple boards for a project.

The main issue is that while creating JQL query, I am not able to select boards.

[Rich Bayless]

It's such a shame that all of the answers given so far are simply workarounds to Jira's apparent limitation of not being able to specify a specific board (or boards) in the JQL itself (as the op actually asked).  And, none of those workarounds support searching across multiple specific boards.  For example, if my project has twenty boards, and I want to find all issues from just five specific boards (of my project) which meet a specific set of criteria, there's apparently no way to do that.  Even worse, it's been a year and a half since this question was asked and Jira still doesn't offer a solution for what should be super simple (e.g., "AND Board = ________").  {sigh}

What's especially bizarre about this limitation is that Jira does support specifying a specific board in REST queries (e.g., to get the internal IDs of all sprints for a specific board: https://{jira site/instance}/rest/agile/1.0/board/68696/sprint) ... how did Atlassian manage to add such support for REST but not JQL?!?!?

[Shivam Desai]

Hi @Niraj Shakya 

Kindly follow the below steps and you will get the solution to your question.

1. Go to the Board
2. In the top-right, select Options (3-dots) and choose Board Settings
3. Go to the General tab on the left-hand menu
4. Select "Edit Filter Query"
5. In the URL, take a note of the filter's ID; it will look like this - ?filter=XXXX - take the numbers after the equals
6. Now go into Issue Search and you can enter something such as project = ABC and filter = XXXXX - that will let you search by project and "board"

Thanks & Regards,

Shivam.

[Nicholas Juncos]

This is a nice workaround. Thank you.

[Sakina]

@Niraj Shakya  you should just use filters that you are using in your board.. ex if your board is component specific you just need to add that component filter to your query.

you can see your board filter in board general settings

[Stephen]

@Sakina The advice from you will definitely not work. He is not asking for Project, rather boards. There is no way to run a query for boards. See the above comment from Richard. if it was a Project, yes, your advise would work.

[Nelson Loia Jr.]

Hi!

I am with a similar doubt: 

There's a project with several EPICs for many teams working in it.

We built a Board for a 3rd party company with tickets associated with a single EPIC.

Now I want to export such board to "play" with the data in a Excel file.

But, I cannot find a way to clear make it.

The pictures I have are:
1 - 58 tickets in the board , when looking to the backlog feature.
2 - 50 tickets in the board, when looking to the "List" feature.
3 - 61 tickets, when I query them (JQL), based in the associated EPIC.

How to export only & exactly the tickets from this board, no mater it's status nor type?

THX!

[Fabio Racobaldo _Herzum_]

Hi @Niraj Shakya ,

welcome to the Atlassian community!

As said by @Shivam Desai , you can retrieve the filter associated to your board. In order to retrive issues associated to your open sprint you need to add the following condition to that filter :

AND sprint in openSprints()

Hope this helps,

Fabio

[Shivam Desai]

Agreed @Fabio

Thanks for the addition.