Github: Issues

Description

• Basic information about issues as well as additional fields for things like assignees, projects, labels and open time

Supported Data Sources

• GitHub

Columns

Type	Name	Description
INTEGER	issue_id	The unique ID of an issue.
STRING	body	The text body of the issue's main description
DATETIME	closed_at	The timestamp for when an issue was last closed. "null" for issues that are open
DATETIME	created_at	The timestamp for when an issue was created
BOOLEAN	is_locked	Boolean indicating if the issue is locked.
INTEGER	milestone_id	Foreign key that references the milestone table representing the current milestone the issue is in
INTEGER	issue_number	The number of the issue. Is unique within a repository, but not accross
BOOLEAN	is_pull_request	Boolean indicating whether the issue is a pull request
INTEGER	repository_id	Foreign key that references the repository table
STRING	state	Whether the issue is open or closed
STRING	title	The title of the issue
DATETIME	updated_at	Timestamp of when the issue was last updated
INTEGER	user_id	Foreign key that references the user table.
STRING	url_link	a link to the issue on github.com
DECIMAL	days_issue_open	The number of days an issue has been open
INTEGER	number_of_times_reopened	Total number of times the issue was reopened
STRING	labels	A list of the labels that are currently applied to the issue
INTEGER	number_of_comments	The total number of comments included in the issue
STRING	repository	The repository that the issue is applicable to
STRING	repository_team_names	An aggreate of the teams associated with the repository
STRING	assignees	The current list of users assigned to the issue
STRING	creator_login_name	User that created the issue login name
STRING	creator_name	User that created the issue name.
STRING	creator_company	User that created the issue company name.