Issues
Lists all project issues.
View-Specific Information
You must specify the UserLogin when executing a SELECT query against this view. You can specify the values in the WHERE clause or as connection properties. A value specified in the WHERE clause takes precedence over the connection property.
If you do not specify a UserLogin value, the adapter will use the login name of the authenticated user.
Select
The adapter uses the GitHub Data API API to restrict results to the specified UserLogin and RepositoryName values.
The adapter processes other filters client-side within the adapter.
- UserLogin and State support the following operator: =
- RepositoryName and Author support the following operators: =,!=
- ClosedAt, CreatedAt, and UpdatedAt support the following operators: =,>,>=,<,<=
SELECT * FROM Issues WHERE UserLogin = 'MyUser' AND RepositoryName = 'MyRepo' SELECT * FROM Issues WHERE RepositoryName = 'test' AND UpdatedAt >= '2018-05-10 11:11:38.0'
Columns
| Name | Type | OrderBySupport | Description |
| Id [KEY] | String | The Issue ID. | |
| UserLogin | String | The login name of the user. | |
| RepositoryName | String | The name of the repository. | |
| ActiveLockReason | String | Reason that the conversation was locked. | |
| Author | String | The username of the actor who authored the comment. | |
| AuthorAssociation | String | Author's association with the subject of the comment. | |
| Body | String | Identifies the body of the issue. | |
| BodyHTML | String | The body rendered to HTML. | |
| BodyText | String | Identifies the body of the issue rendered to text. | |
| Closed | Boolean | True if the object is closed (definition of closed may depend on type). | |
| ClosedAt | Datetime | Identifies the date and time when the object was closed. | |
| CreatedAt | Datetime | True | Identifies the date and time when the object was created. |
| CreatedViaEmail | Boolean | Check if this comment was created via an email reply. | |
| DatabaseId | Int | Identifies the primary key from the database. | |
| Editor | String | The username of the actor who edited the comment. | |
| IncludesCreatedEdit | Boolean | Check if this comment was edited and includes an edit with the creation data. | |
| LastEditedAt | Datetime | The moment the editor made the last edit. | |
| Locked | Boolean | True if the object is locked. | |
| MilestoneId | String | Identifies the milestone associated with the issue. | |
| Number | Int | Identifies the issue number. | |
| PublishedAt | Datetime | Identifies when the comment was published at. | |
| ResourcePath | String | The HTTP path for this issue. | |
| State | String | Identifies the state of the issue.
The allowed values are open, closed. | |
| Title | String | Identifies the issue title. | |
| UpdatedAt | Datetime | True | Identifies the date and time when the object was last updated. |
| Url | String | The HTTP URL for this issue. | |
| ViewerCanReact | Boolean | Can user react to this subject. | |
| ViewerCanSubscribe | Boolean | Check if the viewer is able to change their subscription status for the repository. | |
| ViewerCanUpdate | Boolean | Check if the current viewer can update this object. | |
| ViewerDidAuthor | Boolean | Did the viewer author this comment. | |
| ViewerSubscription | String | Identifies if the viewer is watching, not watching, or ignoring the subscribable entity. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Comments | Integer | You can search by the number of comments. |
| Interactions | Integer | You can filter issues by the number of interactions. |
| Reactions | Integer | You can filter issues by the number of reactions. |
| Mentions | String | You can find issues that mention a certain user. |
| Assignee | String | You can find find issues and pull requests that are assigned to a certain user. |