Create, update, and query the status configuration for a specific object schema in Jira Assets.

Table Specific Information

Select

The add-in uses the Jira Assets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.

• Id supports the following operators: =, IN
• ObjectSchemaId supports the following operators: =, IN

The following queries are processed server-side:

    SELECT * FROM ObjectSchemaStatusTypes WHERE Id = 123
    SELECT * FROM ObjectSchemaStatusTypes WHERE Id IN (1, 2, 35)
    SELECT * FROM ObjectSchemaStatusTypes WHERE ObjectSchemaId = '1'
    SELECT * FROM ObjectSchemaStatusTypes WHERE ObjectSchemaId IN ('1', '2')

Insert

To add a record, you must specify at least the Name, Category, and ObjectSchemaId fields.

  INSERT INTO ObjectSchemaStatusTypes (Category, Name, Description, ObjectSchemaId) VALUES ('1', 'Test1', 'A test desc')

Update

To update a record, specify the field to update and the new value.

UPDATE ObjectSchemaStatusTypes SET Name='RENAMED' WHERE Id=35;

Delete

To delete a record, you must specify the Id.

DELETE FROM ObjectSchemaStatusTypes WHERE Id=36

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id of the ObjectSchemaStatusTypes.
Name	String	False	The Name of the ObjectSchemaStatusTypes.
Description	String	False	The Description of the ObjectSchemaStatusTypes.
Category	Integer	False	The Category of the ObjectSchemaStatusTypes.
ObjectSchemaId	String	False	The ObjectSchemaId of the ObjectSchemaStatusTypes.