Boards
Query, insert and delete the agile Boards in Jira.
Table Specific Information
Select
The add-in uses the Jira API to process some of the filters. The add-in processes other filters within the add-in.
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 Id of the board. | |
| Name | String | False | = | Common |
The name of the board. | |
| Type | String | False | = | Common |
The type of the board. 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 |
Filter the agile boards based on the project they are located in. |
| FilterId | String |
ID of a filter that the user has permissions to view. Not supported for next-gen boards. |