Maintains a catalog of labels available in a repository, enabling effective categorization and filtering of issues and pull requests.

Table-Specific Information

Select

The component uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:

• Name supports the '=,IN' comparison operators.

For example, the following queries are processed server-side:

SELECT * FROM [Labels]
SELECT * FROM [Labels] WHERE [Name] = 'Val1'

The component processes other filters client-side within the component.

The component uses the GitHub API to process ORDER BY clause conditions that are built with the following columns:

• Name
• CreatedAt

SELECT * FROM [Labels] ORDER BY [Name]
SELECT * FROM [Labels] ORDER BY [CreatedAt]

The component processes ordering by other columns client-side within the component.

Insert

You can use the following columns to create (insert) a new record:

• Name
• Description
• Color

INSERT INTO [Labels] ([Name], [Description], [Color]) VALUES ('TestLabel', 'A test label.', 'ffffff')

Update

You can use the following columns to update a record:

• Name
• Description
• Color

UPDATE [Labels] SET [Name] = 'ChangedName', [Description] = 'Changed description.', [Color] = 'd73a4a' WHERE [Id] = 'LA_kwDOLkrwGs8AAAACOC3ntw'

Delete

You can specify the following column to delete a record: Id

DELETE FROM [Labels] WHERE [Id] = 'LA_kwDOLkrwGs8AAAACOC3ntw'

Columns