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 of the Configuration user guide.
After 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 JIRA, you can check the Searching for Issues tutorial from the JIRA documentation.
Search operation can be performed based on main database custom fields, as well as on 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 Power Database Fields. 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 value "dbi_value" or "dbi_value2" for example, you ca use the "in" operator like this:
DBI in (dbi_value, dbi_value2)