Check which Board type is Scrum and Kanban in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
How to check which Board type is Scrum and Kanban in Jira? There are couple ways to determine this.
Environment
Jira Server / Data Center
Solution
JIRA UI
From JIRA UI, you may acces:
JIRA_URL/secure/ManageRapidViews.jspa > Filter by Board type
From the TOP Menu: Boards > View all boards > Filter by Board type
Rest API
You can retrieve this by going on the Browser and entering the following URLs:
JIRA_URL/rest/agile/1.0/board ( It will retrieve all the boards on the instance, you can check the field "type:" )
JIRA_URL/rest/agile/1.0/board?type=kanban ( It will filter and retrieve all boards of KANBAN type only )
JIRA_URL/rest/agile/1.0/board?type=scrum ( It will filter and retrieve all boards of SCRUM type only )
Database
The table in the database responsible to stored the board data is AO_60DB71_RAPIDVIEW.
All Scrum board have this flag enabled "SPRINTS_ENABLED" = 'true'
All Kanban boards have this flag disabled "SPRINTS_ENABLED" = 'false'
To retrieve all Scrum Boards
1
select * from "AO_60DB71_RAPIDVIEW" where "SPRINTS_ENABLED" = 'true'To retrieve all Kanban Boards
1
select * from "AO_60DB71_RAPIDVIEW" where "SPRINTS_ENABLED" = 'false'Was this helpful?