Lists organization repositories with all of their custom property values.

Table-Specific Information

Select

The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

• OrganizationLogin supports the '=,IN' comparison operators.
• RepositoryName supports the '=' comparison operator.
• Name supports the '=' comparison operator.
• Value supports the '=,!=,IS,IS_NOT' comparison operators.

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

SELECT * FROM [RepositoryCustomPropertyValues]
SELECT * FROM [RepositoryCustomPropertyValues] WHERE [OrganizationLogin] = 'Val1'
SELECT * FROM [RepositoryCustomPropertyValues] WHERE [RepositoryName] = 'Val1'
SELECT * FROM [RepositoryCustomPropertyValues] WHERE Name='PropA' AND Value='Val1'

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

Upsert

You can use the following columns to upsert a record:

• OrganizationLogin
• RepositoryName
• Name
• Value

UPSERT INTO [RepositoryCustomPropertyValues] ([OrganizationLogin], [RepositoryName], [Name], [Value]) VALUES ('login', 'Repo1', 'PropA', 'test')

Delete

You can specify the following columns to delete a record:

• OrganizationLogin
• RepositoryName
• Name

DELETE FROM [RepositoryCustomPropertyValues] WHERE (([OrganizationLogin] = 'login') AND ([RepositoryName] = 'Repo1')) AND ([Name] = 'PropA')

Columns