Skip to main content
Contact a Moderator

Question

3
Replies
170
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.
Posted: 3 years ago
Posted: 23 Jul 2018 6:59 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Technical Lead
Pegasystems Inc.
IN

Hi Dinesh,


By default there are no index on pxurgecnywork. Creating index on this should help.

 


Regards,

Ujjwal

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

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice