Groups

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

Table-Specific Information

The connector uses the Jira API to process filters based on the Name column. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

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

Insert a group by specifying the Name column.

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

Delete a group by specifying the Id or Name column.

DELETE FROM Groups WHERE Name = 'engineering-team';
DELETE FROM 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.