How to display more than 25 rows for data objects on Service Catalog

Document ID : KB000045486
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

Allows users to see more than 25 rows when searching through a data object with variable

Background:

There is a data object with variable that returns greater than 25 rows being called from a select control within a form designer form. After providing the input and selecting 'Search' the following message is displayed along with the first 25 rows:

"Only the first 25 rows of the search result will be displayed. Please refine the report query for more results".

However there is no way to access the subsequent rows and currently pagination is not implemented for this page.

Environment: 

Service Catalog 14.1

Instructions: 

Per current design there is no pagination on the lookup field for select controls and tables. However, as a workaround, you can customize the associated xsl to return the required number of rows:

  1. Take a backup of:
    • USM_HOME%\view\webapps\usm\explorer\reports\reportsvariableswithresults.xsl
  2. Update "25" within the following to the appropriate number of rows you would like to return:
    • <input type="hidden" name="Args" value="25" /> <!-- ROWS PER PAGE -->
  3. Stop View service
  4. Delete the contents of %USM_HOME%\view\translets
  5. Start View service

See below:

Editing XSL file

Additional Information:

  • Please note that this file (reportsvariableswithresults.xsl) can be overwritten by a patch/service pack and would recommend implementing this customization according to the "Customizing - How to Customize XSL, XML, JavaScript, and Image Files" section of the Implementation Guide.