Question

1
Replies
433
Views
MathavakrishnanK Member since 2014 3 posts
Incessant
Posted: 2 years ago
Last activity: 2 years 8 months ago
Closed

Wild card search on report definition where condition

All,

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 IDEmployee NameCompany NameArea NameCity
1000001Frank Silver WrightABC Corp LtdBishopgateLondon
1000002Frank Gold WrightABC Corp InternationalLiverpool StreetLondon
1000003Frank Silver CorABC LtdMoorgateLondon

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.

3.)

When search is done with following values,

Employee Name: Frank Silver

Company Name: ABC

Result shall contain only Row 1 and Row 3.

Approach:

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
Share this page LinkedIn