JDBC Driver for GitHub

Build 23.0.8847

Items

Lists items information within the project.

View-Specific Information

Select

The 本製品 processes filters client-side within the 本製品.

Columns

Name Type References OrderBySupport Description
Id [KEY] String The item ID.
DatabaseId Int Identifies the primary key from the database.
FullDatabaseId Long Identifies the primary key from the database.
UpdatedAt Datetime Identifies the date and time when the object was last updated.
CreatedAt Datetime Identifies the date and time when the object was created.
IsArchived Bool Whether the item is archived.
Type String The type of the item.
DraftIssueId String The ID of the draft issue.
DraftIssueTitle String The title of the draft issue.
DraftIssueBody String The body of the draft issue.
DraftIssueBodyText String The body of the draft issue rendered to text.
DraftIssueBodyHTML String The body of the draft issue rendered to HTML.
DraftIssueUpdatedAt Datetime Identifies the date and time when the object was last updated.
DraftIssueCreatedAt Datetime Identifies the date and time when the object was created.
IssueId String The Issue ID.
IssueDatabaseId Int Identifies the primary key from the database.
IssueFullDatabaseId Long Identifies the primary key from the database as a BigInt.
IssueTitle String Identifies the issue title.
IssueTitleHTML String Identifies the issue title rendered to HTML.
IssueAuthor String The username of the actor who authored the comment.
IssueAuthorAssociation String Author's association with the subject of the comment.
IssueEditor String The username of the actor who edited the comment.
IssueBody String Identifies the body of the issue.
IssueBodyText String Identifies the body of the issue rendered to text.
IssueBodyHTML String The body rendered to HTML.
IssueBodyResourcePath String The http path for this issue body.
IssueBodyUrl String The http URL for this issue body.
IssueNumber Int Identifies the issue number.
IssueState String Identifies the state of the issue.
IssueStateReason String Identifies the reason for the issue state.
IssueLocked Bool True if the object is locked.
IssueActiveLockReason String Reason that the conversation was locked.
IssueClosed Bool True if the object is closed (definition of closed may depend on type).
IssueIsPinned Bool Indicates whether or not this issue is currently pinned to the repository issues list.
IssueIncludesCreatedEdit Bool Check if this comment was edited and includes an edit with the creation data.
IssueCreatedViaEmail Bool Check if this comment was created via an email reply.
IssueResourcePath String The HTTP path for this issue.
IssueUrl String The HTTP URL for this issue.
IssueLastEditedAt Datetime The moment the editor made the last edit.
IssuePublishedAt Datetime Identifies when the comment was published at.
IssueClosedAt Datetime Identifies the date and time when the object was closed.
IssueUpdatedAt Datetime True Identifies the date and time when the object was last updated.
IssueCreatedAt Datetime True Identifies the date and time when the object was created.
IssueMilestoneId String Identifies the milestone associated with the issue.
IssueMilestoneTitle String Identifies the title of the milestone.
IssueMilestoneNumber Int Identifies the number of the milestone.
IssueIsReadByViewer Bool Is this issue read by the viewer.
IssueViewerDidAuthor Bool Did the viewer author this comment?
IssueViewerSubscription String Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
IssueViewerCanClose Bool Indicates if the object can be closed by the viewer.
IssueViewerCanReopen Bool Indicates if the object can be reopened by the viewer.
IssueViewerCanDelete Bool Check if the current viewer can delete this object.
IssueViewerCanReact Bool Can user react to this subject?
IssueViewerCanSubscribe Bool Check if the viewer is able to change their subscription status for the repository.
IssueViewerThreadSubscriptionStatus String Identifies the viewer's thread subscription status.
IssueViewerThreadSubscriptionFormAction String Identifies the viewer's thread subscription form action.
IssueViewerCanUpdate Bool Check if the current viewer can update this object.
IssueViewerCannotUpdateReasons String Reasons why the current viewer can not update this comment.
IssueCommentCount Int The number of comments on the issue.
IssueReactionCount Int The number of reactions on the issue.
PullRequestId String The ID of the pull request.
PullRequestDatabaseId Int Identifies the primary key from the database.
PullRequestFullDatabaseId Long Identifies the primary key from the database as a BigInt.
PullRequestAuthor String The actor's login name who authored the comment.
PullRequestAuthorAssociation String Author's association with the subject of the comment.
PullRequestEditor String The actor's login name who edited this pull request's body.
PullRequestHeadRepositoryOwner String The owner's login name of the repository associated with this pull request's head Ref.
PullRequestMergedBy String The actor's login name who merged the pull request.
PullRequestBaseRefId String Identifies the ID of the base ref associated with the pull request, even if the ref has been deleted.
PullRequestBaseRefOid String Identifies the OID of the base ref associated with the pull request, even if the ref has been deleted.
PullRequestBaseRefPrefix String Identifies the prefix of the base Ref associated with the pull request.
PullRequestBaseRefName String Identifies the name of the base Ref associated with the pull request, even if the ref has been deleted.
PullRequestHeadRefId String Identifies the ID of the head ref associated with the pull request, even if the ref has been deleted.
PullRequestHeadRefOid String Identifies the OID of the head ref associated with the pull request, even if the ref has been deleted.
PullRequestHeadRefPrefix String Identifies the prefix of the head Ref associated with the pull request.
PullRequestHeadRefName String Identifies the name of the head Ref associated with the pull request, even if the ref has been deleted.
PullRequestTitle String Identifies the pull request title.
PullRequestTitleHTML String Identifies the pull request title rendered to HTML.
PullRequestBody String The body as Markdown.
PullRequestBodyText String The body rendered to text.
PullRequestBodyHTML String The body rendered to HTML.
PullRequestState String Identifies the state of the pull request.
PullRequestNumber Int Identifies the pull request number.
PullRequestMergeable String Whether or not the pull request can be merged based on the existence of merge conflicts.
PullRequestMerged Bool Whether or not the pull request was merged.
PullRequestClosed Bool true if the pull request is closed.
PullRequestChangedFiles Int The number of changed files in this pull request.
PullRequestAdditions Int The number of additions in this pull request.
PullRequestDeletions Int The number of deletions in this pull request.
PullRequestTotalCommentsCount Int Returns a count of how many comments this pull request has received.
PullRequestReviewDecision String The current status of this pull request with respect to code review.
PullRequestLocked Bool true if the pull request is locked.
PullRequestActiveLockReason String Reason that the conversation was locked.
PullRequestIsDraft Bool Identifies if the pull request is a draft.
PullRequestIsCrossRepository Bool The head and base repositories are different.
PullRequestMaintainerCanModify Bool Indicates whether maintainers can modify the pull request.
PullRequestCreatedViaEmail Bool Check if this comment was created via an email reply.
PullRequestIncludesCreatedEdit Bool Check if this comment was edited and includes an edit with the creation data.
PullRequestMergeCommitId String The commit ID that was created when this pull request was merged.
PullRequestPotentialMergeCommitId String The commit ID that GitHub automatically generated to test if this pull request could be merged. This field will not return a value if the pull request is merged, or if the test merge commit is still being generated. See the mergeable field for more details on the mergeability of the pull request.
PullRequestPermalink String The permalink to the pull request.
PullRequestResourcePath String The HTTP path for this pull request.
PullRequestChecksResourcePath String The HTTP path for the checks of this pull request.
PullRequestRevertResourcePath String The HTTP path for reverting this pull request.
PullRequestUrl String The HTTP URL for this pull request.
PullRequestChecksUrl String The HTTP URL for the checks of this pull request.
PullRequestRevertUrl String The HTTP URL for reverting this pull request.
PullRequestLastEditedAt Datetime The moment the editor made the last edit.
PullRequestMergedAt Datetime The date and time that the pull request was merged.
PullRequestClosedAt Datetime Identifies the date and time when the object was closed.
PullRequestPublishedAt Datetime Identifies when the comment was published at.
PullRequestUpdatedAt Datetime True Identifies the date and time when the object was last updated.
PullRequestCreatedAt Datetime True Identifies the date and time when the object was created.
PullRequestMilestoneId String Identifies the milestone's ID associated with the pull request.
PullRequestMilestoneTitle String Identifies the title of the milestone.
PullRequestMilestoneNumber Int Identifies the number of the milestone.
PullRequestAutoMergeRequestCommitHeadline String The commit title of the auto-merge request. If a merge queue is required by the base branch, this value will be set by the merge queue when merging.
PullRequestAutoMergeRequestAuthorEmail String The email address of the author of this auto-merge request.
PullRequestAutoMergeRequestCommitBody String The commit message of the auto-merge request. If a merge queue is required by the base branch, this value will be set by the merge queue when merging.
PullRequestAutoMergeRequestEnabledAt Datetime When was this auto-merge request was enabled.
PullRequestAutoMergeRequestMergeMethod String The merge method of the auto-merge request. If a merge queue is required by the base branch, this value will be set by the merge queue when merging.
PullRequestViewerDidAuthor Bool Did the viewer author this comment?
PullRequestIsReadByViewer Bool Is this pull request read by the viewer?
PullRequestViewerSubscription String Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
PullRequestViewerCanClose Bool Indicates if the object can be closed by the viewer.
PullRequestViewerCanReact Bool Can user react to this subject?
PullRequestViewerCanReopen Bool Indicates if the object can be reopened by the viewer.
PullRequestViewerCanSubscribe Bool Check if the viewer is able to change their subscription status for the repository.
PullRequestViewerCanApplySuggestion Bool Whether or not the viewer can apply suggestion.
PullRequestViewerCanEditFiles Bool Can the viewer edit files within this pull request?
PullRequestViewerCanDeleteHeadRef Bool Check if the viewer can restore the deleted head ref.
PullRequestViewerCanDisableAutoMerge Bool Whether or not the viewer can disable auto-merge.
PullRequestViewerCanEnableAutoMerge Bool Whether or not the viewer can enable auto-merge.
PullRequestViewerCanMergeAsAdmin Bool Indicates whether the viewer can bypass branch protections and merge the pull request immediately.
PullRequestViewerCanUpdate Bool Check if the current viewer can update this object.
PullRequestViewerCanUpdateBranch Bool Whether or not the viewer can update the head ref of this PR, by merging or rebasing the base ref. If the head ref is up to date or unable to be updated by this user, this will return false.
PullRequestViewerCannotUpdateReasons String Reasons why the current viewer can not update this comment.
PullRequestViewerLatestReviewRequestId String The ID of the viewer's latest review request.
PullRequestViewerLatestReviewId String The ID of the viewer's latest review.
PullRequestIsMergeQueueEnabled Bool Indicates whether the pull request's base ref has a merge queue enabled.
PullRequestIsInMergeQueue Bool Indicates whether the pull request is in a merge queue.
PullRequestMergeQueueEntryId String The ID of this entry in the queue.
PullRequestMergeQueueEntryJump Bool Whether this pull request should jump the queue.
PullRequestMergeQueueEntryPosition Int The position of this entry in the queue.
PullRequestMergeQueueEntrySolo Bool Does this pull request need to be deployed on its own?
PullRequestMergeQueueEntryState String The state of this entry in the queue.
PullRequestMergeQueueEntryEnqueuedAt Datetime The date and time this entry was added to the merge queue.
PullRequestMergeQueueEntryEstimatedTimeToMerge Int The estimated time in seconds until this entry will be merged.
PullRequestMergeQueueEntryBaseCommitId String The ID of the base commit in the queue entry.
PullRequestMergeQueueEntryHeadCommitId String The ID of the head commit in the queue entry.
PullRequestMergeQueueEntryMergeQueueId String The ID of the entry's queue.
PullRequestMergeQueueEntryMergeQueueUrl String The HTTP URL for this merge queue.
PullRequestMergeQueueEntryMergeQueueResourcePath String The HTTP path for this merge queue.
PullRequestMergeQueueEntryMergeQueueNextEntryEstimatedTimeToMerge Int The estimated time in seconds until a newly added entry would be merged.
TitleId String The ID of the value.
TitleDatabaseId Int Identifies the primary key from the database.
TitleCreatorLogin String The actor who created the item.
TitleCreatedAt Datetime Identifies the date and time when the object was created.
TitleUpdatedAt Datetime Identifies the date and time when the object was last updated.
TitleText String Text value of a field.
StatusId String The ID of the value.
StatusDatabaseId Int Identifies the primary key from the database.
StatusCreatorLogin String The actor who created the item.
StatusCreatedAt Datetime Identifies the date and time when the object was created.
StatusUpdatedAt Datetime Identifies the date and time when the object was last updated.
StatusName String The name of the selected single select option.
StatusNameHTML String The html name of the selected single select option.
StatusDescription String A plain-text description of the selected single-select option, such as what the option means.
StatusDescriptionHTML String The description of the selected single-select option, including HTML tags.
StatusColor String The color applied to the selected single-select option.
StatusOptionId String The id of the selected single select option.
RepositoryId String The ID of the repository.
RepositoryDatabaseId Int Identifies the primary key from the database.
RepositoryName String The name of the repository.
RepositoryNameWithOwner String The repository's name with owner.
RepositoryOwnerId String The repository's owner ID.
RepositoryOwnerLogin String The login field of a user or organization.
RepositoryVisibility String Indicates the repository's visibility level.
RepositoryDiskUsage Int The number of kilobytes this repository occupies on disk.
RepositoryForkCount Int Returns how many forks there are of this repository in the whole network.
RepositoryStargazerCount Int Returns a count of how many stargazers there are on this object.
RepositoryWatcherCount Int The number of watchers in a repository.
RepositoryTopicCount Int The number of topics that have been applied to the repository.
RepositoryTempCloneToken String Temporary authentication token for cloning this repository.
RepositoryWebCommitSignoffRequired Bool Whether contributors are required to sign off on web-based commits in this repository.
RepositoryUsesCustomOpenGraphImage Bool Whether this repository has a custom image to use with Open Graph as opposed to being represented by the owner's avatar.
RepositoryDescription String The description of the repository.
RepositoryDescriptionHTML String The description of the repository rendered to HTML.
RepositoryShortDescriptionHTML String A description of the repository, rendered to HTML without any links in it.
RepositoryResourcePath String The HTTP path for this repository.
RepositoryProjectsResourcePath String The HTTP path listing the repository's projects.
RepositoryUrl String The HTTP URL for this repository.
RepositoryHomepageUrl String The repository's URL.
RepositoryMirrorUrl String The repository's original mirror URL.
RepositoryProjectsUrl String The HTTP URL listing the repository's projects.
RepositorySecurityPolicyUrl String The security policy URL.
RepositorySSHUrl String The SSH URL to clone this repository.
RepositoryOpenGraphImageUrl String The image used to represent this repository in Open Graph data.
RepositoryMergeCommitTitle String How the default commit title will be generated when merging a pull request.
RepositoryMergeCommitMessage String How the default commit message will be generated when merging a pull request.
RepositorySquashMergeCommitTitle String How the default commit title will be generated when squash merging a pull request.
RepositorySquashMergeCommitMessage String How the default commit message will be generated when squash merging a pull request.
RepositoryDeleteBranchOnMerge Bool Whether or not branches are automatically deleted when merged in this repository.
RepositoryHasDiscussionsEnabled Bool Indicates if the repository has the Discussions feature enabled.
RepositoryHasIssuesEnabled Bool Indicates if the repository has issues feature enabled.
RepositoryHasProjectsEnabled Bool Indicates if the repository has the Projects feature enabled.
RepositoryHasWikiEnabled Bool Indicates if the repository has wiki feature enabled.
RepositoryHasVulnerabilityAlertsEnabled Bool Whether vulnerability alerts are enabled for the repository.
RepositoryHasSponsorshipsEnabled Bool Indicates if the repository displays a Sponsor button for financial contributions.
RepositoryIsInOrganization Bool Indicates if a repository is either owned by an organization, or is a private fork of an organization repository.
RepositoryIsBlankIssuesEnabled Bool Returns true if blank issue creation is allowed.
RepositoryIsSecurityPolicyEnabled Bool Returns true if this repository has a security policy.
RepositoryIsUserConfigurationRepository Bool Is this repository a user configuration repository?
RepositoryIsArchived Bool Indicates if the repository is unmaintained.
RepositoryIsDisabled Bool Returns whether or not this repository disabled.
RepositoryIsEmpty Bool Returns whether or not this repository is empty.
RepositoryIsFork Bool Identifies if the repository is a fork.
RepositoryIsLocked Bool Indicates if the repository has been locked or not.
RepositoryIsMirror Bool Identifies if the repository is a mirror.
RepositoryIsPrivate Bool Identifies if the repository is private.
RepositoryIsTemplate Bool Identifies if the repository is a template that can be used to generate new repositories.
RepositoryLockReason String The reason the repository has been locked.
RepositoryTemplateRepositoryId String The ID of the repository from which this repository was generated, if any.
RepositoryParentId String The repository parent ID, if this is a fork.
RepositoryForkingAllowed Bool Whether this repository allows forks.
RepositoryAutoMergeAllowed Bool Whether or not Auto-merge can be enabled on pull requests in this repository.
RepositorySquashMergeAllowed Bool Whether or not squash-merging is enabled on this repository.
RepositoryRebaseMergeAllowed Bool Whether or not rebase-merging is enabled on this repository.
RepositoryMergeCommitAllowed Bool Whether or not PRs are merged with a merge commit on this repository.
RepositoryAllowUpdateBranch Bool Whether or not a pull request head branch that is behind its base branch can always be updated even if it is not required to be up to date before merging.
RepositoryViewerPermission String The users permission level on the repository. Will return null if authenticated as an GitHub App.
RepositoryViewerSubscription String Identifies if the viewer is watching, not watching, or ignoring the subscribable entity.
RepositoryViewerHasStarred Bool Returns a boolean indicating whether the viewing user has starred this starrable.
RepositoryViewerDefaultCommitEmail String The last commit email for the viewer.
RepositoryViewerDefaultMergeMethod String The last used merge method by the viewer or the default for the repository.
RepositoryViewerPossibleCommitEmails String A list of emails this viewer can commit with.
RepositoryViewerCanAdminister Bool Indicates whether the viewer has admin permissions on this repository.
RepositoryViewerCanSubscribe Bool Check if the viewer is able to change their subscription status for the repository.
RepositoryViewerCanCreateProjects Bool Can the current viewer create new projects on this owner?
RepositoryViewerCanUpdateTopics Bool Indicates whether the viewer can update the topics of this repository.
RepositoryCodeOfConductId String The ID of the Code of Conduct.
RepositoryCodeOfConductName String The formal name of the Code of Conduct.
RepositoryCodeOfConductBody String The body of the Code of Conduct.
RepositoryCodeOfConductKey String The key for the Code of Conduct.
RepositoryCodeOfConductUrl String The HTTP URL for this Code of Conduct.
RepositoryCodeOfConductResourcePath String The HTTP path for this Code of Conduct.
RepositoryDefaultBranchRefId String The ref id.
RepositoryDefaultBranchRefName String The ref name.
RepositoryInteractionAbilityLimit String The current limit that is enabled on this object.
RepositoryInteractionAbilityOrigin String The origin of the currently active interaction limit.
RepositoryInteractionAbilityExpiresAt Datetime The time the currently active limit expires.
RepositoryLatestReleaseId String The ID of the release.
RepositoryLatestReleaseName String The title of the release.
RepositoryLicenseId String The ID of the license associated with the repository.
RepositoryLicenseKey String The key of the license associated with the repository.
RepositoryLanguageId String The ID of the current primary language.
RepositoryLanguageName String The name defined for the current language.
RepositoryLanguageColor String The color defined for the current language.
RepositoryPushedAt Datetime Identifies when the repository was last pushed to.
RepositoryArchivedAt Datetime Identifies the date and time when the repository was archived.
RepositoryCreatedAt Datetime Identifies the date and time when the object was created.
RepositoryUpdatedAt Datetime True Identifies the date and time when the object was last updated.
MilestoneId String The ID of the milestone.
MilestoneTitle String Identifies the title of the milestone.
MilestoneClosed Bool True if the object is closed (definition of closed may depend on type).
MilestoneProgressPercentage Double Progress Percentage for this milestone.
MilestoneDescription String Identifies the description of the milestone.
MilestoneNumber Int True Identifies the number of the milestone.
MilestoneState String Identifies the state of the milestone.
MilestoneResourcePath String The HTTP path for this milestone.
MilestoneUrl String The HTTP URL for this milestone.
MilestoneViewerCanClose Bool Indicates if the object can be closed by the viewer.
MilestoneViewerCanReopen Bool Indicates if the object can be reopened by the viewer.
MilestoneDueOn Datetime True Identifies the due date of the milestone.
MilestoneClosedAt Datetime Identifies the date and time when the object was closed.
MilestoneUpdatedAt Datetime True Identifies the date and time when the object was last updated.
MilestoneCreatedAt Datetime True Identifies the date and time when the object was created.
IterationId String The ID of the value.
IterationDatabaseId Int Identifies the primary key from the database.
IterationCreatorLogin String The actor who created the item.
IterationCreatedAt Datetime Identifies the date and time when the object was created.
IterationUpdatedAt Datetime Identifies the date and time when the object was last updated.
IterationTitle String The title of the iteration.
IterationTitleHTML String The title of the iteration, with HTML.
IterationStartDate Date The start date of the iteration.
IterationDuration Int The duration of the iteration in days.
IterationIterationId String The ID of the iteration.
CustomNameId String The ID of the value.
CustomNameDatabaseId Int Identifies the primary key from the database.
CustomNameCreatorLogin String The actor who created the item.
CustomNameCreatedAt Datetime Identifies the date and time when the object was created.
CustomNameUpdatedAt Datetime Identifies the date and time when the object was last updated.
CustomNameText String Text value of a field.
CustomNumberId String The ID of the value.
CustomNumberDatabaseId Int Identifies the primary key from the database.
CustomNumberCreatorLogin String The actor who created the item.
CustomNumberCreatedAt Datetime Identifies the date and time when the object was created.
CustomNumberUpdatedAt Datetime Identifies the date and time when the object was last updated.
CustomNumberNumber Double Number as a float.
CustomDateId String The ID of the value.
CustomDateDatabaseId Int Identifies the primary key from the database.
CustomDateCreatorLogin String The actor who created the item.
CustomDateCreatedAt Datetime Identifies the date and time when the object was created.
CustomDateUpdatedAt Datetime Identifies the date and time when the object was last updated.
CustomDateDate Date Date value for the field.
CustomSelectId String The ID of the value.
CustomSelectDatabaseId Int Identifies the primary key from the database.
CustomSelectCreatorLogin String The actor who created the item.
CustomSelectCreatedAt Datetime Identifies the date and time when the object was created.
CustomSelectUpdatedAt Datetime Identifies the date and time when the object was last updated.
CustomSelectName String The name of the selected single select option.
CustomSelectNameHTML String The html name of the selected single select option.
CustomSelectDescription String A plain-text description of the selected single-select option, such as what the option means.
CustomSelectDescriptionHTML String The description of the selected single-select option, including HTML tags.
CustomSelectColor String The color applied to the selected single-select option.
CustomSelectOptionId String The id of the selected single select option.
CustomIterationId String The ID of the value.
CustomIterationDatabaseId Int Identifies the primary key from the database.
CustomIterationCreatorLogin String The actor who created the item.
CustomIterationCreatedAt Datetime Identifies the date and time when the object was created.
CustomIterationUpdatedAt Datetime Identifies the date and time when the object was last updated.
CustomIterationTitle String The title of the iteration.
CustomIterationTitleHTML String The title of the iteration, with HTML.
CustomIterationStartDate Date The start date of the iteration.
CustomIterationDuration Int The duration of the iteration in days.
CustomIterationIterationId String The ID of the iteration.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8847