Lists all issues displayed on agile boards, including their rank and column placement.

View-Specific Information

SELECT

The connector uses the Jira API to process filters based on the BoardId column. The connector processes all other filters client-side.

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 unique identifier of the issue as stored in Jira.
Key	String	Issues.Key	=,IN	Common	The issue key, which is a human-readable identifier composed of the project key and issue number (such as 'PROJ-123').
BoardId [KEY]	Integer	Boards.Id	=,IN	Common	The ID of the board that includes this issue. This links the issue to a specific agile board (for example, Scrum or Kanban).
IssueTypeId	String	Issuetypes.Id	=,!=,IS,IS NOT,IN,NOT IN	Common	The unique identifier for the issue type (such as 'task', 'story', 'bug') assigned to the issue.
IssueTypeName	String		=,!=,IS,IS NOT,IN,NOT IN	Common	The display name of the issue type, which describes the nature of the issue (for example, 'Story', 'Bug', or 'Task').
StatusId	Integer	Statuses.Id	=,!=,IS,IS NOT,IN,NOT IN	Common	The ID of the current status of the issue, used internally in Jira's workflow engine.
StatusName	String		=,!=,IS,IS NOT,IN,NOT IN	Common	The name of the current status of the issue, such as 'To Do', 'In Progress', or 'Done'.
ProjectId	Integer	Projects.Id	=,!=,IS,IS NOT,IN,NOT IN	Common	The internal ID of the project that the issue belongs to.
ProjectKey	String	Projects.Key	=,!=,IS,IS NOT,IN,NOT IN	Common	The short code identifier of the project (for example, 'PROJ') that this issue is part of.
ProjectName	String		=,!=,IS,IS NOT,IN,NOT IN	Common	The name of the project to which the issue belongs.
ClosedSprintsAggregate	String			Common	A list of sprints that this issue has previously been assigned to and that are now closed. This provides historical sprint data.
Created	Datetime		=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp when the issue was initially created in Jira.
Updated	Datetime		=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN	Common	The timestamp of the last update made to the issue, including changes to status, assignees, or fields.