Excel Add-In for Jira

Build 24.0.9062

ProjectRoles

Query roles for all projects in Jira.

Select

The 本製品 will use the Jira API to process filters that refer to ProjectId and ProjectKey while the rest of the filter is executed client side within the 本製品. The Jira APIs support filters using the equals (=) or IN operator with ProjectId and ProjectKey.

For example, the following queries are processed server side:

Retrieve all roles for each project:

SELECT * FROM ProjectRoles

Retrieve all roles for a specific project:

SELECT * FROM ProjectRoles WHERE ProjectId = '10000'

Columns

Name Type References SupportedOperators Platform Description
RoleId [KEY] Long

Roles.Id

Common The Id of the role.
RoleName String

Roles.Name

Common The name of the role.
ProjectId [KEY] Integer

Projects.Id

=,IN Common The Id of the project associated with the role.
ProjectKey [KEY] String

Projects.Key

=,IN Common The key of the project associated with the role.

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