ObjectSchema

Create, update, and query the ObjectSchema in Jira Assets.

Select

The connector uses the Jira Assets API to process the query. The filter is executed client-side within the connector.

To add an ObjectSchema, you must specify at least the Name and ObjectSchemaKey.

  INSERT INTO ObjectSchema (Name, ObjectSchemaKey)
    VALUES ('ObjectSchemaTest', 'OST')

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

To delete a ObjectSchema, you must specify its ID.

For example:

DELETE FROM ObjectSchema WHERE ID=1


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.