How can I find Boards / Filters relating to a specific project

Question

For any given project within JIRA is there an easy way of identifying all the Kanban or Scrum boards associated with it (if there are any)? I appreciate that a board's filter doen't need to contain a project name (it could for example just show all issues of type 'Bug') but if it's easier I'd just be interested in boards (filters) where the project name is part of the JQL.

If there isn't an 'easy' way to achieve this does anyone know the SQL that I'd need to run to find this?

Thanks

Roystine Machado · Answer

This doesn't work if you have similar project key's or project name's like 
1. ERP
2. ERP BIS

3. ERP SCS

etc.

any better solution ?

Michael Kuhl_s2wdwg · Answer

The REST API offers a (rather tedious) way.

Get all boards with this call:

GET /rest/agile/1.0/board (Doc)

Then for each board returned get the projects for each board:

GET /rest/agile/1.0/board/{boardId}/project (Doc)

The response will include project info:

"self": "http://www.example.com/jira/rest/api/2/project/EX", "id": "10000", "key": "EX", "name": "Example",

Andreas von Euw · Answer

To get at least a 95% list of boards for a Project you can try this SQL:

select b.NAME as boardname, f.filtername, f.reqcontent from AO_60DB71_RAPIDVIEW b, SEARCHREQUEST f where b.SAVED_FILTER_ID = f.id and reqcontent like '%YOURPROJECTKEY%'