Boards
Query, insert and delete the agile Boards in Jira.
Table Specific Information
Select
The connector uses the Jira API to process some of the filters. The connector processes other filters within the connector.
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. |