Display more than 25 rows for data objects on Service Catalog
search cancel

Display more than 25 rows for data objects on Service Catalog

book

Article ID: 45486

calendar_today

Updated On:

Products

CA Service Catalog

Issue/Introduction

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

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

Release: 14.1 or higher
Component:  CA Service Catalog

Resolution

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.  The line of interest is 119, highlighted below (preceding default text included for context):
          var url = '<xsl:value-of select="concat($baseURL, icservletname)"/>';
        url += '?Node=<xsl:value-of select="concat('icguinode.',util:getNodeWithHandle('reportviewforselect',icuser/securityhandle))"/>';
        url += '&amp;Args=<xsl:value-of select="$html_DataID"></xsl:value-of>';
        url += '&amp;Args=' + encodeURIComponent(ret[0]);
          url += '&amp;Args=&amp;Args=&amp;Args=25&amp;Args=1&amp;Args=&amp;Args=&amp;Args=&amp;Args=&amp;Args=&amp;Args=&amp;Args=&amp;Args='
  3. Stop Catalog service
  4. Move the contents of %USM_HOME%\view\translets to a separate folder for backup, then delete the contents of %USM_HOME%\view\translets
  5. Start Catalog service

Additional Information

File reportsvariableswithresults.xsl can be overwritten by a patch/service pack and would recommend implementing this customization according to the "Modify XSL, XML, JavaScript, and Image Files" section of the Implementation Guide.

Please test the above in a non-prod environment first before attempting in production