IBM FileNet P8, Version 5.2.1

Setting case-insensitive search behavior for the workflow system

You can configure the property value comparisons in query search conditions to be performed in a case-insensitive manner.

About this task

Content Platform Engine implements case-insensitive search behavior by including the LOWER function on the property and on the string value in query statements, so that the search condition becomes LOWER(property)=LOWER('Value'). However, for the following databases, the administration console cannot create supporting indexes in this way because the LOWER function is not supported on a column in an index:

DB2® for Linux, UNIX and Windows before version 10.5 does not support case-insensitive search for workflows.
For SQL Server, a case-insensitive collation is the default collation. If you use this collation, there is no need to enable case-insensitive search for the isolated region. Therefore, disable the Force case-insensitive search isolated region setting in the administration console. The default setting is disabled.

You cannot force search behavior to be case-sensitive: in the absence of forced case-insensitivity, property value comparisons operate in a manner that is determined by the configured behavior of the underlying database. This underlying behavior might be case-insensitivity.

Procedure

To set case-insensitive search behavior:

Access the Isolated Region tab in the administration console:
1. In the domain navigation pane, click the object store name.
2. In the object store navigation pane, click Administrative > Workflow System > Isolated Regions > region name.
For the Force Case Insensitive Search property, select True.
Save your changes.