Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

How to correct the Case Insensitive warning for list view rules

Suggest edit Updated on September 20, 2019

Summary

Remediate this high-priority warning before using the rule in a production environment.

In v5.4 sp2 or greater, use the Download High Priority Warnings option in the Application Preflight tool to research all high-priority warnings in your application. As a best practice, perform the preflight check before you lock a RuleSet version.

Rule TypeWarning Type
Rule-Obj-ListViewPerformance
NameCase Insensitive
MessageCase Insensitive search operation can adversely impact performance.To improve performance create functional index using UPPER() function on the columns that need case insensitive search.
DetailsN/A
Severity3


Suggested Approach

If you select Ignore Case on the Content tab as shown here:

you will get this warning when you save the rule:

Case insensitive searches can be costly. In most cases, leave this box cleared. Select this box only when truly necessary to obtain the rows of the report:

  • If your PegaRULES database is hosted by Microsoft SQL Server, comparisons are always case-insensitive, so selecting this box does not affect the report contents, but may add processing.
  • If your PegaRULES database is hosted by Oracle, IBM UDB or most other database vendor products, selecting this box may affect which rows appear in the report when values occur in mixed case. However, conversion to uppercase can significantly slow database processing.
  • Case conversion is meaningful only for properties of type Text, Identifier or Password. Regardless of database software, case conversion is not needed for numbers, dates, or text that contains only uppercase or only lowercase characters.

To improve performance you can create an additional column in database with the capitalized text. When doing the comparison, capitalize the search data as well.

The procedure to create UPPER indexes varies by database platform. Your DBA should consult the product documentation for information on how to create the indexes.

Tags

Pega Platform 7.1.1 - 7.4 Reporting Financial Services Healthcare Insurance Media and Advertising Government Life Sciences Utilities Hospitality and Entertainment Manufacturing Retail
Did you find this content helpful? YesNo

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us