...

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 has been set 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 JIRAJira, you can check the Searching for Issues tutorial from the JIRA Jira documentation.

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

Basically, to perform an issue search based on a database custom field value, you will use the Issue Navigator:

Image Removed

Image Added

Custom fields can be searched, as you can see in the bottom part of the navigator panel, but note that they will only appear in the search form on the left can be added using the More button when appropriate. That is:

...

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

...

There is a known issue when installing this plugin via UPM: the database custom fields won't be displayed on the search screen of JIRA.

This is caused by a known JIRA bug: https://jira.atlassian.com/browse/JRA-25284 and will probably be resolved in future JIRA releases.

So far the workaround to resolve this issue temporarily without restarting JIRA is to go to the Custom Field admin screen, click Edit for any of the custom fields provided by the plugin, then save the field without making any changes.

...

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 also

Searchers - making database custom fields searchable