BoardIssues
Query the agile Board Issues 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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following queries are processed server side:
SELECT * FROM BoardIssues WHERE BoardId = '1' SELECT * FROM BoardIssues WHERE BoardId IN (70,215)
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | Integer |
Issues.Id | =,IN | Common | The Id of the issue. |
| Key | String |
Issues.Key | =,IN | Common | The key of the issue. |
| BoardId [KEY] | Integer |
Boards.Id | =,IN | Common | The board the issue is included in. |
| IssueTypeId | String |
IssueTypes.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue type Id. |
| IssueTypeName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue type name. | |
| StatusId | Integer |
Statuses.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue status Id. |
| StatusName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The issue status name. | |
| ProjectId | Integer |
Projects.Id | =,!=,IS,IS NOT,IN,NOT IN | Common | The project Id of the issue. |
| ProjectKey | String |
Projects.Key | =,!=,IS,IS NOT,IN,NOT IN | Common | The project key of the issue. |
| ProjectName | String | =,!=,IS,IS NOT,IN,NOT IN | Common | The project name of the issue. | |
| ClosedSprintsAggregate | String | Common | The issue's previous sprints that have been closed. | ||
| Created | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The creation date of the issue. | |
| Updated | Datetime | =,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The updated date of the issue. |