Changing Data Retrieval Page Size Options (Drill Value)

Unless their ability to do so has been disabled by the administrator, end-users can select the number of records they want to retrieve per page in a data retrieval operation (data query, list selection, or drill transaction). By default, the available values are 25, 50, 100, and 200.

The administrator can globally change the available values by configuring a setting in the portalconfig.xml file. For example, if you don’t want users to be able to retrieve 200 records per page, you can remove 200 from the list.

If you want users to be able to select 15, 30, 45 or 60 records (rather than 25, 50, 100 or 200), you can change the values in the list.

You could also add values to the list (25, 50, 75, 100, 200, 300). All entries must be separated by a vertical bar (|) character.

Note: Typically, a larger page size slows performance. Do not change the value to greater than 200 unless you know that your system performance will not be adversely affected.

To change available drill values

  1. Open the portalconfig.xml file for editing. This file is located on the web server in:

    /DocumentRoot/lawson/MyLawsonPortal/portalconfig.xml

  2. Make the changes you want to make to the drill_values attribute in the <SETTING id> node. (The <SETTING ID> nodes are between the <SETTINGS></SETTINGS> tags near the top of the portalconfig.xml file.)

    Example:

    Suppose you want to remove the ability to retrieve 200 records but retain the other default page size options. You would change the value of drill_values as shown below.

    <SETTING id="drill_values" value="25|50|100"/>

    If you are removing values, remove vertical bar separators that are no longer needed; if you are adding values, be sure to separate values with vertical bar characters.