Skip to Main Content

Info

Searching in Interactive Grids may not give the results you expect.
The search only returns results for Text columns, so numbers, dates, etc. are ignored.

The obvious solution is to convert numbers etc. to an (extra) text column, and then use that in the report. In the example below I've done that with Empno.
There is another option however, using LOVs. It's a bit weird to (mis)use a "select null from dual" for that, but it does work. See the Deptno, Mgr and Hiredate columns below. And not having to convert columns and/or define extra columns is a nice bonus as well.

In the examples below, the first (standard) IG will only show search results for text (Ename) and number (Deptno and Mgr) columns.
The second (text + LOV) IG will show search results for all columns.

EMP

EMP_TEXT

Code

Region

Identification
Sequence
Title
Type
Source
Source Type
Table Name

View

View
Name
DDL

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading
Settings
Based On
Appearance
Format Mask

Region

Identification
Sequence
Title
Type
Source
Source Type
Table Name

View

View
Name
DDL

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading

Report Column

Definition
Column Name
Type
Heading
Column Heading
Settings
Based On
Column Definition
Type
SQL Query
Display Extra Values

Report Column

Definition
Column Name
Type
Heading
Column Heading
Settings
Based On
Column Definition
Type
SQL Query
Display Extra Values

Report Column

Definition
Column Name
Type
Heading
Column Heading
Settings
Based On
Appearance
Format Mask
Column Definition
Type
SQL Query
Display Extra Values