Searching Issues

Before performing an issue search based on a database custom field value, you must set a search template for that custom field. To do so, follow the steps described in the Searcher section.

After you set a searcher for the database custom field, you can perform a search for all issues containing the desired value for that custom field. For a detailed explanation on searching issues in Jira, you can check the Searching for issues tutorial from the Jira documentation.

Search operation can be performed based on the main database custom fields, as well as on the child database custom fields.

Custom fields can be searched, but note that they can be added using the More button when appropriate. That is:

Custom fields that relate to a particular project will only appear in the search form after you choose that project.
Custom fields that relate to a particular issue type will only appear in the search form after you choose that issue type.

After introducing the desired value to search for in the database custom field (as simple text value), and selecting any other needed filters, press the search button.

All issues containing the searched value for that database custom field will be displayed in the right part of the search panel, as in the screenshot above.

Advanced search

We also support advanced search in the Power Database Fields PRO™. You can use "=", "in" operators and so on.

For instance, you have a DBI database custom field with a "10000" id, you can search by using either the custom field name (DBI) or the id (cf[10000]). If you want to search issues for which DBI has "dbi_value" value for example, then the JQL will be:

DBI = dbi_value

or

cf[10000] = dbi_value

If you want to search issues for which DBI has "dbi_value" or "dbi_value2" value for example, you can use the "in" operator like this:

DBI in (dbi_value, dbi_value2)

See More