JDBC Driver for Jira

Build 22.0.8462

MyPermissions

Query the available Permissions of the current user in JIRA.

Table Specific Information

Select

The driver processes all filters specified on this table client-side within the driver.

SELECT * FROM MyPermissions

Columns

Name Type References SupportedOperators Platform Description
Id [KEY] Integer Common The Id of the permission.
Key [KEY] String Common The key of the permission.
Name String Common The name of the permission.
Type String Common The type of the permission.
Description String Common The description of the permission.
HavePermission Boolean Common Boolean indicating if the permission is set or not.
DeprecatedKey Boolean Common Boolean indicating if the permission is deprecated.
Permissions String = Common Permissions as comma seperated values.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ProjectKey String The key of the project associated with the permission.
ProjectId String The Id of the project associated with the permission.
IssueKey String The key of the issue associated with the permission.
IssueId String The Id of the issue associated with the permission.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462