BoardIssues
Lists all issues displayed on agile boards, including their rank and column placement.
Table Specific Information
Select
The cmdlet uses the Jira API to process some of the filters. The cmdlet processes other filters within the cmdlet.
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. |