Retrieves the users and groups associated with specific issue security levels, which control visibility of issues.

View-Specific Information

SELECT

The connector uses the Jira API to process filters based on the IssueSecuritySchemeId and IssueSecurityLevelId columns. The connector processes all other filters client-side.

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

SELECT * FROM IssueSecurityLevelMembers WHERE IssueSecuritySchemeId = '10000';
SELECT * FROM IssueSecurityLevelMembers WHERE IssueSecuritySchemeId = '10000' AND IssueSecurityLevelId = '10001';

Columns

Name	Type	References	SupportedOperators	Description
Id [KEY]	String		=,IN	A unique identifier for the issue security level member record.
IssueSecurityLevelId	String		=,IN	The ID of the specific security level assigned to issues to control visibility.
IssueSecuritySchemeId	String		=,IN	The ID of the security scheme that includes this issue security level.
HolderParameter	String			An optional parameter used to identify the permission holder. Recommended when group names might change.
HolderType	String			The type of entity that holds the permission, such as a group, user, or project role.
HolderValue	String			The specific identifier (such as group name or user ID) for the permission holder, used in conjunction with the holder type.