EM: Databases/SQL: Databases
> Search
Description
The 
Databases Search Provides a searchable interface for locating database objects using keywords or queries, with an option to open a query builder dialog that assists in constructing structured search expressions.
Note: selecting a database from Databases name list, opens its configuration interface, and enabling access to Search.
Location
EM Navigator → 
Databases/SQL → Databases → Search
Toolbar
| Button | Function |
|---|---|
|
Opens dialog to build Lucene query using structured input fields. |
|
Executes search using entered query and displays matching results. |
Search Criteria Settings
Provides input controls for defining search criteria, including query text, table filtering options, and maximum number of results returned.
Search Criteria Settings
| Settings | Description |
|---|---|
|
Search Words or Lucene Query |
Allows entry of search text or Lucene query, link opens documentation explaining supported query syntax and usage. |
|
The table or database scope used to filter and limit search results. |
|
|
The maximum number of search results returned and displayed in the results list. |
Lucene Query Builder
Click the icon to open the Lucene Query Builder dialog, where you can construct search queries using structured fields such as all words, exact phrases, exclusions, proximity, and ranges, with the computed query displayed for confirmation before execution.
Lucene Query Builder Settings
| Settings | Description |
|---|---|
|
All entered words included in the generated Lucene query to match entries containing all specified terms. |
|
|
Specified phrase included in the generated Lucene query as an exact match in the same order. |
|
|
Specified words included in the generated Lucene query to match entries containing any of them. |
|
|
Specified words included in the generated Lucene query as optional matching terms. |
|
|
Entered phrase included in the generated Lucene query with a proximity condition applied, allowing terms to appear near each other rather than in an exact sequence. The specified value in the within words of each other field requires a numeric value and defines the maximum word distance permitted between terms for proximity evaluation. Additionally, the In the range between and fields require numeric values and define optional range boundaries that constrain the values included in the generated query, further refining the matching criteria. |
|
|
Displays the fully constructed Lucene query string based on all defined criteria before insertion into the Search Words field. |
Search: Column Settings
Search results presented in a tabular format, listing matching table names and associated data preview information based on the defined search criteria.
Search: Column Settings
| Settings | Description |
|---|---|
|
Table name displayed for each result entry returned based on the defined search criteria. |
|
|
Data preview content associated with each result entry, reflecting available information for the listed table. |
Result Count
Number of results currently returned and shown in the results list based on the applied search criteria.