turbot/github

GitHub
steampipe plugin install githubsteampipe plugin install github

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,
description
from
github_search_label
where
repository_id = 331646306
and query = 'bug enhancement blocked';

List labels where specific text matches in name or description

select
id,
repository_id,
name,
description
from
github_search_label
where
repository_id = 331646306
and query = 'work';

.inspect github_search_label

Find labels in a repository with names or descriptions that match search keywords.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
colortextThe color assigned to the label.
defaultbooleanWhether the label is a default one.
descriptiontextThe description of the label.
idbigintThe ID of the label.
nametextThe name of the label.
querytextThe query used to match the label.
repository_full_nametextThe full name of the repository (login/repo-name).
repository_idbigintThe ID of the repository.
scoredouble precisionThe score of the label.
text_matchesjsonbThe text match details.
urltextThe API URL to get the label details.