Boards

Enables management of agile boards in Jira. Supports creation, querying, modification, and deletion of boards.

Table Specific Information

Select

The server uses the Jira API to process some of the filters. The server processes other filters within the server.

The following is an example of a query with server-side filters

SELECT * FROM Boards WHERE Id = 10022

Using other filters:

SELECT * FROM Boards WHERE ProjectKeyOrId = 'QMTH' AND Type = 'scrum'

Insert

To insert a new board you must specify Name, Type and FilterId.

INSERT INTO Boards (Name, Type, FilterId) VALUES ('New board', 'scrum', 10200)

Delete

To delete a board you must specify its Id.

DELETE FROM Boards WHERE Id = 130

Columns


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	Integer	True		=	Common	The unique identifier of the board, used to reference it within Jira.
Name	String	False		=	Common	The display name of the board, typically used in the Jira interface and UI components.
Type	String	False		=	Common	The type of board, such as 'scrum' or 'kanban', which determines how work is organized and visualized. The allowed values are scrum, kanban, simple.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ProjectKeyOrId	String	Filters the results to only include boards associated with the specified project key or project ID.
FilterId	String	Filters the results to only include boards configured with the specified filter ID. This is not supported for next-gen boards.