Question
3
Replies
117
Views
Cognizant Technology Solutions India PVT Ltd
Posted: 2 years ago
Last activity: 2 years 2 months ago
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
Posted: 2 years ago
Posted: 2 years ago
Hi Dinesh,
By default there are no index on pxurgecnywork. Creating index on this should help.
Regards,
Ujjwal
Posted: 2 years ago
You have to optimise Loan officer,pxUrgencyWork will be optimised by default
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.