Create, update, and manage the global status configuration in Jira Assets. These status types are available across all schemas.

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
• Name supports the following operator: =

The following queries are processed server-side:

    SELECT * FROM GlobalStatusTypes
    SELECT * FROM GlobalStatusTypes WHERE Id = 85
    SELECT * FROM GlobalStatusTypes WHERE Id IN (2, 85, 17)
    SELECT * FROM GlobalStatusTypes WHERE Name = 'Waiting for Approval'

Insert

To add a global status type, you must specify at least the Category and the Name.

INSERT INTO GlobalStatusTypes (Category, Name, Description) VALUES ('1', 'TestGLOBAL', 'A GLOBAL desc')

Update

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

UPDATE GlobalStatusTypes SET Name ='TestGLOBAL_updated' WHERE Id = '98'

Delete

To delete a record, you must specify the Id.

DELETE FROM GlobalStatusTypes WHERE Id = '98'

Columns

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