Retrieves role definitions that can be assigned across projects, such as 'Developers' or 'Administrators'.

View-Specific Information

SELECT

The driver uses the Jira API to process filters based on the ProjectId and ProjectKey columns. The driver processes all other filters client-side.

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

SELECT * FROM ProjectRoles WHERE ProjectId = '10000';

Columns

Name	Type	References	SupportedOperators	Platform	Description
RoleId [KEY]	Long	Roles.Id		Common	A unique identifier for the project role. Project roles define a set of permissions and responsibilities within a specific Jira project.
RoleName	String	Roles.Name		Common	The display name of the project role, such as 'Developers', 'Administrators', or 'Users'.
ProjectId [KEY]	Integer	Projects.Id	=,IN	Common	The numeric ID of the project that this role is associated with.
ProjectKey [KEY]	String	Projects.Key	=,IN	Common	The unique key of the project where this role is defined, used to reference the project in Jira queries and configurations.