Support Article
case sensitive while search in ListView
SA-5357
Summary
Searches with ListView appear to be case-insensitive but searching the DB directly appears to be case-sensitive.
When using the Ignore Case option in ListView, the search becomes case insensitive . However, PPRC gives the following warning while saving the Listview :
Caution - Performance
Case Insensitive search operation can adversely impact performance. To improve performance create functional index using UPPER() function on the columns that need case insensitive search
Error Messages
No output get generated
Steps to Reproduce
1. Mark the checkbox to use Ignore Case option in ListView
Root Cause
This is an intended behavior. The PDN article explains on the correcting the warning messages.
Resolution
PRPC OOTB Listview search is case sensitive, we need to use Ignore Case option in order to get case insensitive. PRPC gives a warning message for activating Ignore Case
Please check the below PDN for correcting the warning message:
https://pdn.pega.com/reporting/how-to-correct-the-case-insensitive-warning-for-list-view-rules
We can have a look at the extracts from ListView help on Ignore Case:
Select to cause runtime tests or comparisons of the Field value and the Value value to occur after the system converts both to uppercase. If selected, then at runtime "a" matches "A" and is less than "B".
Clear to cause tests of the Field value and the Value value to occur without case conversion. In this case, "a" is greater than "A" and also greater than "B"
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 alwayscase-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 orPassword. Regardless of database software, case conversion is not needed for numbers, dates, or text that contains only uppercase or only lowercase characters.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.