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.

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.
Tables	The table or database scope used to filter and limit search results.
Max 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
With ALL the words	All entered words included in the generated Lucene query to match entries containing all specified terms.
With the EXACT phrase	Specified phrase included in the generated Lucene query as an exact match in the same order.
With AT LEAST ONE of the words	Specified words included in the generated Lucene query to match entries containing any of them.
WITHOUT the words	Specified words included in the generated Lucene query as optional matching terms.
With APPROXIMATE phrase	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.
Computed Query	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	Table name displayed for each result entry returned based on the defined search criteria.
Data Preview	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.

See Also

Lucene Query

BBjAdminBase

Databases

JDBC How-To

Tables

Views

Procedures

Types

Security

Query Analysis

Permissions

Connection Pools

SQL/SELECT Connections

Table Analysis Queue

Index Builders