RepositoryCustomPropertySchemas
Gets all custom properties schemas for repositories.
Table-Specific Information
Select
The 本製品 uses the GitHub API to process WHERE clause conditions that are built with the following column and operators:
- OrganizationLogin supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [RepositoryCustomPropertySchemas]
SELECT * FROM [RepositoryCustomPropertySchemas] WHERE [OrganizationLogin] = 'Val1'
The 本製品 processes other filters client-side within the 本製品.
Upsert
You can use the following columns to upsert a record:
- OrganizationLogin
- Name
- Description
- Required
- ValueType
- DefaultValue
- AllowedValues
- ValuesEditableBy
UPSERT INTO [RepositoryCustomPropertySchemas] ([DefaultValue], [OrganizationLogin], [Name], [ValueType], [Description], [Required], [AllowedValues], [ValuesEditableBy]) VALUES ('Test', 'login', 'PropA', 'multi_select', 'Test description', true, 'A,B,C', 'org_and_repo_actors')
Delete
You can specify the following columns to delete a record:
- OrganizationLogin
- Name
DELETE FROM [RepositoryCustomPropertySchemas] WHERE ([Name] = 'PropA') AND ([OrganizationLogin] = 'login')
Columns
| Name | Type | ReadOnly | References | Description |
| OrganizationLogin [KEY] | String | True |
Organizations.Login |
The organization's login name. |
| Name [KEY] | String | False |
The name of the property. | |
| Description | String | False |
Short description of the property. | |
| Required | Bool | False |
Whether the property is required. | |
| ValueType | String | False |
The type of the value for the property. | |
| DefaultValue | String | False |
Default value of the property. | |
| AllowedValues | String | False |
An ordered list of the allowed values of the property. | |
| ValuesEditableBy | String | False |
Who can edit the values of the property. | |
| Url | String | True |
The URL that can be used to fetch, update, or delete info about this property via the API. | |
| SourceType | String | True |
The source type of the property. |