Create, update, and query the status configuration in Jira Assets.

Select

The driver 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 driver.

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

The following queries are processed server-side:

    SELECT * FROM Status WHERE ID = 123
    SELECT * FROM Status WHERE ID IN (1, 123)
    SELECT * FROM Status WHERE ObjectSchemaId = '1'
    SELECT * FROM Status WHERE ObjectSchemaId IN ('123', '1234')
	,etc.

Insert

To add a Status, you must specify at least the Category and Name.

  INSERT INTO Status (Category, Name)
    VALUES ('CategoryTest', 'Test')

Update

To update an item via an Insert operation, you must specify the field and the new value.

UPDATE	Status
SET		Name='RENAMED' 
WHERE	ID=35

Delete

To delete a Status, you must specify the ID.

For example:

DELETE FROM Status WHERE ID=36

Columns

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