Status

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

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 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