Groups

Lists user groups configured in the Jira instance, including group names and descriptions.

Select

The add-in uses the Jira API to process filters on supported columns. Any additional filters are applied client-side by the add-in.

SELECT * FROM GROUPS WHERE Name <> 'administrator' AND CONTAINS(Name, 'jira')

Creates a new group.

To add a group, you must provide at least the Name column.

INSERT INTO Groups (Name) VALUES('engineering-team')

Deletes an existing group.

In the below examples, a group is deleted by Name and Id.

DELETE Groups WHERE NAME = 'engineering-team'
DELETE Groups WHERE Id = 'dfe32267-633a-421a-a5f8-cc2a4z83e711'

Note: To delete a group and transfer its restrictions to another group refer to the DeleteAndSwapGroup stored procedure.


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	String	True		=	Cloud	A unique identifier for the group, used internally to reference the group within Jira.
Name [KEY]	False	True		=,!=,CONTAINS	Common	The name of the group as it appears in Jira. This is typically used for permission schemes and role assignments.
Html	String	True			Common	The raw HTML representation of the group object. This may be used in UI rendering or API responses.
LabelsAggregate	String	True			Common	A comma-separated list of labels that are associated with the group. Labels can help categorize or describe the group's function or purpose.