JDBC Driver for Jira

Build 23.0.8839

Roles

Query the available roles in Jira.

Select

The driver will use the Jira API to process filters that refer to Id while the rest of the filter is executed client side within the driver. The Jira APIs support filters using the equals (=) operator with Id.

For example, the following queries are processed server side:

Retrieve all the available Roles:

SELECT * FROM Roles

Retrieve a specific Role:

SELECT * FROM Roles WHERE Id = '10002'

Update

Update the role name and description by specifying the role Id

UPDATE Roles SET Description = 'test_updated', Name = 'test_updated' WHERE Id = 10002

Delete

Delete a role by specifying the Id.

DELETE FROM Roles WHERE Id = '10002'

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Long False = Common

The Id of the role.

Name String False Common

The name of the role.

Description String False Common

The description of the role.

Actors String False Common

The list of users who act in this role.

Scope String False Cloud

The scope of the role.

IsAdmin Boolean False Cloud

Whether this role is the admin role for the project.

IsDefault Boolean False Cloud

Whether this role is the default role for the project.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839