ObjectSchema
Create, update, and query the ObjectSchema in Jira Assets.
Select
The provider uses the Jira Assets API to process the query. The filter is executed client-side within the provider.
Insert
To add an ObjectSchema, you must specify at least the Name and ObjectSchemaKey.INSERT INTO ObjectSchema (Name, ObjectSchemaKey) VALUES ('ObjectSchemaTest', 'OST')
Update
To update an item, you must specify at least the field and the new value.UPDATE ObjectSchema SET Name='ObjectSchemaUpdated', Description='TestDescription' WHERE Id=1
Delete
To delete a ObjectSchema, you must specify its ID.For example:
DELETE FROM ObjectSchema WHERE ID=1
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The Id of the ObjectSchema. |
Name | String | False |
The Name of the ObjectSchema. |
Description | String | False |
The Description of the ObjectSchema. |
WorkspaceId | String | False |
The WorkspaceId of the ObjectSchema. |
GlobalId | String | False |
The GlobalId of the ObjectSchema. |
ObjectSchemaKey | String | False |
The ObjectSchemaKey of the ObjectSchema. |
Status | String | False |
The Status of the ObjectSchema. |
Created | Datetime | False |
The Created at of the ObjectSchema. |
Updated | Datetime | False |
The Updated at of the ObjectSchema. |
ObjectCount | Integer | False |
The ObjectCount of the ObjectSchema. |
ObjectTypeCount | Integer | False |
The ObjectTypeCount of the ObjectSchema. |
CanManage | Boolean | False |
The CanManage of the ObjectSchema. |