AssignableUsers

Returns users assignable to issues in a specific Jira project.

View-Specific Information

SELECT

The provider applies filters server-side only when supported for the specific column and operator, as documented in the Columns section. All other filters are processed client-side.

You must specify a ProjectKey or ProjectId to retrieve results. If neither is specified, the provider automatically queries the Projects table to retrieve the required identifiers. This may result in increased query times.

Jira Cloud

On Jira Cloud, the following columns support server-side filtering with the = operator:

ProjectId: Filters by project ID. When provided together with ProjectKey, ProjectId takes precedence and the ProjectKey filter is ignored.
ProjectKey: Filters by project key. Ignored when ProjectId is also specified.
AccountId: Filters by the user's Atlassian account ID.
DisplayName: Filters by the user's display name.
EmailAddress: Filters by the user's email address.
AccountType: Filters by the user's account type.

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

SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST';
SELECT * FROM AssignableUsers WHERE ProjectId = 10000;
SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST' AND AccountId = '712020:fcd95543-59da-42bc-a0f2-4ab4265f07d4';
SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST' AND DisplayName = 'John Doe';
SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST' AND AccountType = 'atlassian';

When neither ProjectKey nor ProjectId is specified, the provider automatically queries all projects and retrieves assignable users for each:

SELECT * FROM AssignableUsers WHERE DisplayName = 'John Doe';

Jira Data Center

On Jira Data Center, the following columns support server-side filtering with the = operator:

ProjectKey: Filters by project key.
Name: Filters by the user's username. Using this column performs a single-user lookup by exact username.
DisplayName: Filters by the user's display name (passed as the username query parameter to the Jira API).

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

SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST';
SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST' AND Name = 'jdoe';
SELECT * FROM AssignableUsers WHERE ProjectKey = 'TEST' AND DisplayName = 'John Doe';

When ProjectKey is not specified, the provider automatically queries all projects and retrieves assignable users for each:

SELECT * FROM AssignableUsers WHERE Name = 'jdoe';

NOTE: Starting with Jira Data Center version 8.20, the startAt offset parameter is no longer supported on the user/assignable/search endpoint. As a result, the provider fetches up to the maximum of 100 users per project. On earlier Data Center versions (prior to 8.20), standard pagination is fully supported.

Columns