Utilities for filtering on long string field content in an Oracle database
You can filter based on the content of long string
fields if the Oracle Text feature has been enabled. This is also known
as full text searching.
Warning: Do not include long string
fields that are encrypted using field level encryption in the search
criteria because they can return unexpected results.
If you are using OpenPages® on IBM Software Hub, you must download the full text search utilities before you can apply the filters.
For more information, see Post-provisioning setup for OpenPages.
To apply the filters, enable the Oracle Text feature. For more information, see Enabling Oracle Text. If the Oracle Text feature is not enabled, attempts to filter on the content of long string fields will generate errors.
For details on setting up long text fields, see Long String data type.
There are five utilities provided to help manage full text searching:
- Enabling Oracle Text
- Create a long string index for an Oracle database
- Create a schedule job to synchronize a long string index
- Drop a long string index
- Modifying the list of stop words
To apply filters with long string fields, you must change the setting to true.
| If the value is set to... | Then... |
|---|---|
| true | Filtering is enabled on long string fields. |
| false | Filtering is disabled on long
string fields. The default is false. |
For details on working with settings, see Viewing the Configuration and Settings page.