Close popover
Mathavakrishnan Kannan (MathavakrishnanK)
Pega Manager
MathavakrishnanK Member since 2014 3 posts
Posted: January 25, 2018
Last activity: January 26, 2018

Wild card search on report definition where condition


We need to build a advanced search functionality with more than one search criteria. Facing difficulties in implementing wild card kind of where condition in report definition. See if you could share some ideas for below issue.

Consider a table like below,

Employee ID Employee Name Company Name Area Name City
1000001 Frank Silver Wright ABC Corp Ltd Bishopgate London
1000002 Frank Gold Wright ABC Corp International Liverpool Street London
1000003 Frank Silver Cor ABC Ltd Moorgate London

Search Section having two fields, like below,

Employee Name :

Company Name :

1.) When the search is done with following values,

Employee Name : Frank

Company Name : ABC

Result should contain all the 3 rows from the above table.

2.) When search is done with following values,

Employee Name: Frank Wright

Company Name: ABC Ltd

Result shall contain only Row 1.

The search should match all the words in search string against corresponding column value, even if the words in search string are not in same sequence as the column value.


When search is done with following values,

Employee Name: Frank Silver

Company Name: ABC

Result shall contain only Row 1 and Row 3.


We were trying to build a report definition with where condition type of "Contains" on each column, however this works for scenario 1 & scenario 3. But not for scenario 2.

Any pointers on how to achieve this with a report definition is much appreciated.

More info:

This report definition is called from a Data page.

Using Pega 7.2

***Edited by Moderator Marissa to update categories***

Case Management Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.