Manages the agile boards in Jira.

Table-Specific Information

SELECT

The connector uses the Jira API to process filters based on the Id, ProjectKeyOrId, and Type columns. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

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

Note: Valid Type filter values are scrum, kanban, and simple.

INSERT

Insert a board by specifying the following fields:

• Name
• Type
• FilterId

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

Note: Valid input Type values are scrum and kanban.

DELETE

Delete a board by specifying the 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. For READ operations valid values are 'scrum', 'kanban', and 'simple'. For CREATE operations only 'scrum' and 'kanban' are supported.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
ProjectKeyOrId	String	The key or the Id of the project the board is located in.
FilterId	String	The Id of a filter that the user has permissions to view. Not supported for team-managed boards.