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.

Note:

If the region value for Force Case Insensitive Search is not set, the system uses the object store setting.

When you change Force Case Insensitive Search you need to restart the Content Platform Engine to start using the new value.

Procedure

To set case-insensitive search behavior:

  1. 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.
  2. For the Force Case Insensitive Search property, select True.
  3. Save your changes.