JDBC Driver for Jira

Build 23.0.8839

Boards

Query, insert and delete the agile Boards in Jira.

Table Specific Information

Select

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839