Search for your Custom Fields in JQL search view?

The need

As a Jira user, you often need to search for issues based on custom field values. Elements Connect allows you to integrate external data sources into Jira, and custom fields created via Elements Connect are a key part of your workflow. You might be wondering how to search for these custom fields using Jira Query Language (JQL).

The solution

Elements Connect custom fields can be queried in Jira using specific search operators, depending on the type of field (snapshot or object). Understanding the appropriate search operators and how to use JQL with autocompletes will enable you to find relevant data quickly and effectively.

This documentation is about custom fields only, not Connected Items.

Tutorial

Step 1: Identify your custom field type

• Snapshot fields: these are

  • Multiple-values select lists,

  • Snapshot single-value select lists

  • Read-Only Fields (single or multiple values)

• Object fields: these are single-value select lists where you decided to store an ID and its corresponding value 👇
  

  

  
  

Step 2: choose your JQL search operator

For snapshot fields

• Use the standard search operators in JQL, such as:

  • = (Equals)

  • != (Not Equals)

  • IS (Empty or Null)

  • IS NOT (Empty or Null)

  • IN (Matches one of the provided values)

  • NOT IN(Excludes multiple provided values)

• Example: to find issues where the "CRM Type" custom field matches "Microsoft Dynamics," your query would look like:

  CODE

  "CRM Type" = "Microsoft Dynamics"

• For those fields, you will be able to use autocomplete in JQL mode - you’ll see suggestions as you type in the JQL search bar

For object fields

• Searching for full object values (JSON) or specific properties is possible.

Searching on the full object

You’ll need to use the following operators:

• ~ (Contains)

• !~ (Does not contains)

• IS (Empty or Null)

• IS NOT (Empty or Null)

Example:

• Example JQL for searching an object field based on full object:

  CODE

  "CRM Type" ~ "Microsoft Dynamics"

Searching on full object, you won’t be able to use autocomplete in JQL mode.

Searching on the object property

Meaning the field ID or Value - You’ll need to use the following operators:

• = (Equals)

• != (Not Equals)

• IS (Empty or Null)

• IS NOT (Empty or Null)

• IN (Matches one of the provided values)

• NOT IN(Excludes multiple provided values)

Example: If you're searching by an object's ID or value (such as a database entry), you can use search aliases.

• Example JQL for searching an object field based on its value:

  CODE

  "CRM Type.Value" = "Microsoft Dynamics"

Searching on object properties, you will be able to use autocomplete in JQL mode - you’ll see suggestions as you type in the JQL search bar.