Jira Snippet Library: JQL - Custom Fields

[#1]

You can query for custom fields using their name, their name and type, or their unique ID number.

To find the ID of a custom field in Cloud, login to Jira as an application administrator and visit the Fields admin page. On the top right, click the “Columns” menu and enable “Field ID” by clicking the toggle. Then copy the custom field ID in the table.

The example below shows the “Approver groups” field has the ID: customfield_10092. Change the format of customfield_123 to cf[123]. Ex: Use the format “cf[10092]” in a JQL statement.

Custom fields

Custom number example

Using a field’s unique name.

• Using a field name: cost >= "100"

Using a field’s name and type.

• "cost[number]" >= "100"

Using a field’s unique ID.

• cf[10063] > "100"

Custom user picker example

Sometimes my clients create custom user picker fields like “Developer Name” and “Tester Name” to track who is scheduled to do the work. Then, they use workflow post functions or automation rules to set and update the “Assignee” standard field using the values in these custom fields. E.g., When the item transitions to the “In Dev” status, assign the item to the user listed in the “Developer Name” field.

Formats for user picker custom fields.

• “Developer Name” = currentUser()

• "Developer Name[User Picker (single user)]" = username

• cf[10251] is not EMPTY

---

Back to intro or article list