github_actions_artifactgithub_actions_repository_runnergithub_actions_repository_secretgithub_actions_repository_workflow_rungithub_audit_loggithub_branchgithub_branch_protectiongithub_code_ownergithub_commitgithub_community_profilegithub_gistgithub_gitignoregithub_issuegithub_issue_commentgithub_licensegithub_my_gistgithub_my_issuegithub_my_organizationgithub_my_repositorygithub_my_stargithub_my_teamgithub_organizationgithub_organization_dependabot_alertgithub_organization_external_identitygithub_organization_membergithub_pull_requestgithub_pull_request_commentgithub_pull_request_reviewgithub_rate_limitgithub_rate_limit_graphqlgithub_releasegithub_repositorygithub_repository_collaboratorgithub_repository_dependabot_alertgithub_repository_deploymentgithub_repository_environmentgithub_repository_vulnerability_alertgithub_search_codegithub_search_commitgithub_search_issuegithub_search_labelgithub_search_pull_requestgithub_search_repositorygithub_search_topicgithub_search_usergithub_stargazergithub_taggithub_teamgithub_team_membergithub_team_repositorygithub_traffic_view_dailygithub_traffic_view_weeklygithub_treegithub_usergithub_workflow
Table: github_search_label
The github_search_label
table helps to find labels in a repository with names or descriptions that match search keywords.
You must always include at least one search term and repository ID when searching source code in the where or join clause using the query
and repository_id
columns respectively.
Examples
List labels for bug, enhancement and blocked
select id, repository_id, name, repository_full_name, descriptionfrom github_search_labelwhere repository_id = 331646306 and query = 'bug enhancement blocked';
List labels where specific text matches in name or description
select id, repository_id, name, descriptionfrom github_search_labelwhere repository_id = 331646306 and query = 'work';
.inspect github_search_label
Find labels in a repository with names or descriptions that match search keywords.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
color | text | The color assigned to the label. |
default | boolean | Whether the label is a default one. |
description | text | The description of the label. |
id | bigint | The ID of the label. |
name | text | The name of the label. |
query | text | The query used to match the label. |
repository_full_name | text | The full name of the repository (login/repo-name). |
repository_id | bigint | The ID of the repository. |
score | double precision | The score of the label. |
text_matches | jsonb | The text match details. |
url | text | The API URL to get the label details. |