Page History

Searching on case data will be is case sensitive when using the Oracle database, because Oracle has a Case Sensitive Collation by default. Searching MSSQL is case insensitive by default when if the schema is up to date with all the latest upgrade scripts.

To enable this feature for Oracle we have added an enable script, and furthermore set the feature toggle for case insensitive search needs to be enabled.

The SQL scripts for enabling or disabling case insensitive searching can be found in the release zip in the dbscripts\features folder of the process-sql-store.
This  This script creates an index which enables case-insensitive searching through lists.To enable this feature you should run the enable script, and furthermore set the feature toggle for case insensitive search to enabled.
Like

For the runtime, the feature toggle can be enabled by adding the following property to the application.properties: blueriq.process-sql-store.oracle.case-insensitive-search-enabled=true

To enable this feature for the Customer Data Service you should adjust the blueriqadd the property blueriq.customerdata.oracle.case-insensitive-search-enabled=true in blueriq-customerdata-odata-service-v1.yml or blueriq-customerdata-odata-service-v1.properties

...