ItemsView
Offers a complete and unfiltered view of all project items, facilitating comprehensive project analysis.
View-Specific Information
Select
The add-in processes all filters client-side within the add-in. The following query is the only one processed server-side:
SELECT * FROM [ItemsView]
Columns
| Name | Type | References | OrderBySupport | Description |
| ItemId [KEY] | String | A unique identifier for the item. | ||
| FullDatabaseId | Long | The primary key of the item in the database, represented as a BigInt for scalability. | ||
| UpdatedAt | Datetime | The date and time when the item or its details were last updated. | ||
| CreatedAt | Datetime | The date and time when the item was created. | ||
| IsArchived | Bool | Indicates whether the item is archived and no longer actively managed. | ||
| Type | String | The type of the item, such as 'Issue', 'Pull Request', or another classification. | ||
| PullRequestState | String | The current state of the pull request, such as 'OPEN', 'CLOSED', or 'MERGED'. | ||
| IssueState | String | The current state of the issue, such as 'OPEN', 'CLOSED', or 'IN_PROGRESS'. | ||
| Reason | String | The reason for the current state of the issue, such as 'COMPLETED' or 'NOT_PLANNED'. | ||
| Title | String | The text value representing the title of the item. | ||
| Assignees | String | A comma-separated list of usernames assigned to the item. | ||
| Status | String | The name of the selected option in a single-select status field. | ||
| Labels | String | A comma-separated list of labels applied to the item. | ||
| Linked pull requests | String | A comma-separated list of pull request numbers linked to this item. | ||
| Milestone | String | The title of the milestone associated with this item. | ||
| Repository | String | The full name of the repository containing this item, including the owner's login (for example, 'owner/repository-name'). | ||
| Reviewers | String | A comma-separated list of usernames assigned as reviewers for this item. | ||
| CustomText | String | A text value stored in a custom text field. | ||
| CustomNumber | Double | A numeric value stored in a custom number field, represented as a float. | ||
| CustomDate | Date | A date value stored in a custom date field. | ||
| CustomSingleSelect | String | The name of the selected option in a custom single-select field. | ||
| CustomIteration | String | The title of the iteration associated with this item. |