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’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 could not exceed.
To apply this global limit, edit the following file:
/m-power/mrcjava/WEB-INF/classes/mrc-runtime.properties
Add the following lines:
global_max_rows=20000
global_max_rows_opt_out=DDNAME.R00010,DDNAME.R00020
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.
Note: The developer can still set their application’s “Max Web Records” 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:
Be sure to restart Tomcat after making your changes.
Note: When opting out applications, be sure to comma separate the list. Also, please note that the “s” at the end of the URL is omitted.