IssueSecurityLevelMembers
Retrieves the users and groups associated with specific issue security levels, which control visibility of issues.
View-Specific Information
SELECT
The add-in uses the Jira API to process filters based on the IssueSecuritySchemeId and IssueSecurityLevelId columns. The add-in 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. |