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.
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:
var url = '<xsl:value-of select="concat($baseURL, icservletname)"/>';
url += '?Node=<xsl:value-of select="concat('icguinode.',util:getNodeWithHandle('reportviewforselect',icuser/securityhandle))"/>';
url += '&Args=<xsl:value-of select="$html_DataID"></xsl:value-of>';
url += '&Args=' + encodeURIComponent(ret[0]);
url += '&Args=&Args=&Args=25&Args=1&Args=&Args=&Args=&Args=&Args=&Args=&Args=&Args='
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