How to change the maximum number of records returned by the Lookup List
The Rule-Utility-Function LookupList getDefaultMax function is designed to always return a maximum of 2000 records from the database. This limit prevents performance degradation when thousands of records are returned for every list looked up. However, special situations might require overriding the default limit to satisfy certain business objectives. HFix-6240 for PRPC 6.2 SP1 provides functionality for this scenario. The Suggested Approach explains how to change the maximum number of records to be returned by the Lookup List library function.
Process Commander provides an activity, Code-Security.ApplicationProfileSetup, which is called during logon (after authentication) to perform application-specific initialization. HFix-6240 delivers a change whereby the Rule-Utility-Function LookupList getDefaultMax function reads the maximum number of records from the pyLookupListMaxRecords property in the pxThread page. After installing HFix-6240, you can adjust the default and specify the maximum number of records returned for Lookup Lists.
Caution: To avoid negative performance impact, change the maximum number of records returned for Lookup Lists only when necessary. As an alternative best practice, use a Report Definition as the data source for the Lookup List when feasible.
To adjust the default for the maximum number of records returned for Lookup Lists, perform the following steps for each application that calls the Code-Security.ApplicationProfileSetup activity.
Prerequisite: To have each application define its own maximum number of records returned for Lookup Lists, be sure to define a different Code-Security.ApplicationProfileSetup activity for each application.
- Install HFix-6240 on your PRPC 6.2 SP1 server.
- This hotfix delivers a Rule Utility Function; therefore, be sure to recompile the library for the hotfix to take effect.
- You can recompile the Lookup List library from one of two forms:
- Rule-Utility-Function form of the function getDefaultMax
- Rule-Utility-Library form of the library LookupList.
Do not change the name or the Defined On class.