BoardIssues
Lists all issues displayed on agile boards, including their rank and column placement.
テーブル固有の情報
Select
本製品 はJira API を使用して一部のフィルタを処理します。 本製品 は他のフィルタを本製品 内で処理します。
例えば、次のクエリはサーバー側で処理されます。
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. |