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 driver will use the login name of the authenticated user.

Select

The driver uses the GitHub API to restrict results to the specified UserLogin and RepositoryName values.

The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

• UserLogin and State support the following operator: =
• RepositoryName and Author support the following operators: =,!=
• ClosedAt, CreatedAt, and UpdatedAt support the following operators: =,>,>=,<,<=

The following queries are processed server side.

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.