...
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.
Custom fields can be searched, but note that they 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 in the screenshot above.
...
| title | Jira 4.4.x only |
|---|
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