Question

3
Replies
144
Views
 DINESH KANNAN S (DINESHKANNANS)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN
DINESHKANNANS Member since 2018 7 posts
Cognizant Technology Solutions India PVT Ltd
Posted: July 23, 2018
Last activity: July 23, 2018
Posted: 23 Jul 2018 6:21 EDT
Last activity: 23 Jul 2018 7:31 EDT
Closed

Report Definitions

Hi All,

I am creating a list report which has two following requirements:

1)Group the loan request by loan officer (.loanofficer)

2)Use a filter to return results with an urgency (.pxurgecnywork) greater than 80.

Which property should be optimized? and Why?

can anyone help me with this?

Thanks is Advance,

Dinesh

Reporting
Moderation Team has archived post, 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.
Posted: 3 years ago
Posted: 23 Jul 2018 6:47 EDT
Naveen Kumar Gattupally (Naveen_Naanu)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Dinesh, 


You should optimize all the properties you are using in the report definition. Report definition will not fetch the results from BLOB. 


Use ColumnSource as .pxUrgencyWork with is "is Greater than" provide the number to fetch proper data.


Let me know, in case if you got obstacles in creating the report.