{"id":12395,"date":"2025-02-21T10:26:11","date_gmt":"2025-02-21T16:26:11","guid":{"rendered":"https:\/\/www.mrc-productivity.com\/techblog\/?post_type=ht_kb&#038;p=12395"},"modified":"2025-02-21T10:26:11","modified_gmt":"2025-02-21T16:26:11","slug":"how-to-add-a-global-report-row-limit","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/techblog\/?ht_kb=how-to-add-a-global-report-row-limit","title":{"rendered":"How to Add a Global Report Row Limit"},"content":{"rendered":"\n<p>m-Power defaults a Report row limit of 10,000 rows. This can be modified at the application level, via Application properties, to change the Report&#8217;s max rows limiter to a higher value.<\/p>\n\n\n\n<p>However, there are scenarios where system administrators may want to apply a <strong>global<\/strong> limiter on all reports that developers could not exceed. <\/p>\n\n\n\n<p>To apply this global limit, edit the following file:<br> \/m-power\/mrcjava\/WEB-INF\/classes\/mrc-runtime.properties<br>Add the following lines:<\/p>\n\n\n\n<p>global_max_rows=20000<br>global_max_rows_opt_out=DDNAME.R00010,DDNAME.R00020<\/p>\n\n\n\n<p>In the case above, all reports (except for Report 10 and Report 20 in the DDNAME dictionary) will have a max records capped at 20,000 rows. <\/p>\n\n\n\n<p>Note: The developer can still set their application&#8217;s &#8220;Max Web Records&#8221; to whatever number they choose, but in the event that the number of rows returned exceeds the global max rows value, the user will see the following error:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/techblog\/images\/max_rows_global_error.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Be sure to restart Tomcat after making your changes.<\/p>\n\n\n\n<p>Note: When opting out applications, be sure to comma separate the list. Also, please note that the &#8220;s&#8221; at the end of the URL is omitted.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>m-Power defaults a Report row limit of 10,000 rows. This can be modified at the application level, via Application properties, to change the Report&#8217;s max rows limiter to a higher value. However, there are scenarios where system administrators may want to apply a global limiter on all reports that developers&#8230;<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-12395","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/12395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12395"}],"version-history":[{"count":2,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/12395\/revisions"}],"predecessor-version":[{"id":12397,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/12395\/revisions\/12397"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12395"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=12395"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=12395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}