Users
Provides access to Jira users. Supports querying user details including account ID, email, and group memberships.
Select
本製品 は、次のフィルタ以外のフィルタを、クライアント側で本製品 内部で実行します。 Jira API では、LIKE 演算子を使ったName、DisplayName、およびEmailAddress カラムのフィルタのサポートに制限があります。Name、DisplayName、およびEmailAddress を一度に1つずつ指定します。
Jira はこれらのカラムに基づいたフィルタをActive またはIncludeInactive カラムと組み合わせてサポートします。例えば、次のクエリはサーバー側で処理されます。
SELECT * FROM Users WHERE Name LIKE '%John%' AND Active = false AND IncludeInactive = true
GroupName もしくはGroupId を指定して、特定のグループに属するユーザーをクエリします。
SELECT * FROM Users WHERE GroupName = 'Testing team' SELECT * FROM Users WHERE GroupId = '3dd7e7a1-77f7-4ac1-b8e1-a069830a7f1d'
すべてのグループとそのメンバーのリストを取得することもできます。
SELECT * FROM Users WHERE GroupName IN (SELECT Name FROM Groups)
IssueKey およびProjectKey 疑似カラムを使用して、特定の課題またはプロジェクト内の任意の課題を閲覧できるユーザーを検索します。
SELECT * FROM Users WHERE IssueKey = 'PRJ-1' SELECT * FROM Users WHERE ProjectKey = 'PRJ'
Insert
INSERT への入力はE メールアドレスである必要があります。INSERT INTO Users(EmailAddress) VALUES ('[email protected]')
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| GroupName | String | True | =,IN | Common |
The name of the Jira group that the user belongs to. Groups are used to manage permissions and roles collectively. | |
| EmailAddress | String | False | = | Common |
The primary email address associated with the user's Jira account. This is often used for notifications and communication. | |
| Active | Bool | True | Common |
If the value is 'true', the user account is currently active and able to log in. If the value is 'false', the account is deactivated and cannot access Jira. | ||
| TimeZone | String | True | Common |
The time zone preference set in the user's profile. This affects how times and dates are displayed in the interface for that user. | ||
| Locale | String | True | Common |
The locale setting for the user, which defines the language and regional formatting used in the UI, such as number or date formats. | ||
| AccountId [KEY] | String | True | Cloud |
The globally unique identifier for the user across all Atlassian cloud products. This replaces legacy fields like 'key' and 'name' in cloud environments. | ||
| AccountType | String | False | Cloud |
Indicates the type of user account, such as 'atlassian' for managed users or 'app' for automated or bot accounts. | ||
| Products | String | False |
A comma-separated list of Jira products the user has access to, such as 'jira-core', 'jira-servicedesk', 'jira-product-discovery', or 'jira-software'. This helps determine license usage and available features. | |||
| Key [KEY] | String | True | Server |
The legacy Jira user key. While deprecated in cloud environments, it is still used in server and data center editions for user identification. | ||
| Name | String | False | Server |
The legacy Jira username. This is primarily used in server environments and has been replaced by 'AccountId' in cloud. |