It is possible to search for specific values within a database field using JQL.

JQL Search Example

Given a field like the one configured above, if we wanted to find all the issues that have Nissan cars, we can do that using the JQL function seen below:

issue.property["dbcf"].customfield_11100_make ~ Nissan

Breaking it Down

To see how this function works, lets break it apart:

1. Prefix - This part of the function is static. This syntax should never change:

   issue.property["dbcf"]

2. Field and label - The next part of the function is the id of the custom field that is getting searched (Ids will vary across instances. To look up the id of a custom field use the Custom Field Usage tool). Names and aliases do not work in place of the custom field id. After the underscore is the label, this corresponds to the row in the database field.

   customfield_11100_make

3. Operator and value - It is important to ensure that you are using the proper operator type.

   ~ Nissan

   1. String - When searching strings it is recommended to use “~” and “!~” (contains and does not contain) instead of “=” and “!=” to get the best results.

   2. Numbers and Dates - When searching the normal numerical operators will work, such as “=, !=, <, >

More Examples

1. Search for cares made after 2010:

   issue.property["dbcf"].customfield_11100_year > 2010

2. Searching for a car by year and make:

   issue.property["dbcf"].customfield_11100_year = 2010 AND issue.property["dbcf"].customfield_11100_make ~ Mazda

3. Search for issues missing a value for model:

   issue.property["dbcf"].customfield_11100_model is Empty

4. Sear for issues with cars made in multiple years:

   issue.property["dbcf"].customfield_11100_year in (2010, 2011)