Page History
| Info |
|---|
This feature was originally introduced when we supported Oracle and SQL Server databases (the latter being case insensitive by default). From release 16.4, we also support PostgreSQL, which is case sensitive by default just like Oracle. This feature also applies to PostgreSQL. For now, the properties to enable it are still named after Oracle. |
Searching on case data will be is case sensitive when using an Oracle database, because Oracle has a Case Sensitive Collation case sensitive collation by default. Searching MSSQL SQL Server on the other hand is case insensitive by default when up to date with all the upgrade scripts.The scripts for enabling or disabling case insensitive searching can be found in the dbscripts\features folder of the process-sql-store.
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 : . To overcome these differences, we have built case insensitive search, which enables searching case insensitive on case data regardless of the underlying database.
When running our own performance tests we discovered that under specific circumstances case insensitive search on case data can decrease performance on an Oracle database. For this reason we have disabled this feature by default on Oracle.
This article described how to enable case insensitive search on case data on an Oracle database.
| Note |
|---|
Please run performance tests to see if your installation is affected in any way when enabling this feature. |
Enabling case insensitive search on the runtime
For the runtime, we need to set a specific property and run database scripts to change indexes on a table.
Process engine/Process-sql-store
Runtime property
Add the following property to
| Include Page | ||||
|---|---|---|---|---|
|
| Code Block | ||
|---|---|---|
| ||
blueriq.process-sql-store.oracle.case-insensitive-search-enabled=true |
Database script
Run the SQL script found in the release zip at: blueriq-component-process-sql-store\dbscripts\features\case-insensitive\oracle_enable_feature_case_insensitive.sql
Customerdata
For the customerdata only a property needs to be added to To enable this feature for the Customer Data Service you should adjust the blueriq.customerdata.oracle.case-insensitive-search-enabled=true in blueriq-customerdata-odata-service-v1.yml or :
| Code Block | ||
|---|---|---|
| ||
blueriq:
customerdata:
oracle:
case-insensitive-search-enabled: true |
Disabling the feature
Once enabled, you can disable the feature by reversing the steps above, that is setting the properties to false (or remove them) and run the oracle_disable_feature_case_insensitive.sql script..propertiesP.S. This functionality could hurt performance so use with caution.
More information can be found at :
Process SQL store component
Customerdata service
Reference Guide: Properties
Release 13.6.1 Upgrade Instructions [editor]
Blueriq 13.6.1 Release Notes [editor]
Overview
Content Tools