Opsview - Saved parameters not loading in the browser when editing a scheduled report

Problem

When editing a scheduled report, fields in the Parameters tab are not populated with the saved values of the report.

While this does not impact the functionality of the Reporting module, since the scheduled report still runs and the notifications are send, it results in unnecessary time spent re-entering the values.

This is an open issue with Jaspersoft - [#13126] - Scheduled job parameters not loaded when editing - since October 2020.

In this example, the "Hashtag" field is empty in the Parameters tab.

Workaround

The values of the parameters are stored in the jasperserver MySQL database. Below is a SQL query that will show the current values of the parameters:

SELECT JIReportJob.label AS "Scheduled Report",
       JIReportJobParameter.parameter_name AS "Parameter Name",
       left(JIReportJobParameter.parameter_value, 50) AS "Parameter Value"
FROM JIReportJob
JOIN JIReportJobParameter ON JIReportJob.id = JIReportJobParameter.job_id
WHERE JIReportJob.label like '%NAME OF REPORT%';

Script

This shell script (showparams.sh) will display the parameters of a report.

Copy it to your orchestrator and run ./showparams.sh <report name>.

#!/usr/bin/env bash

if [[ $# -gt 0 ]]; then
  REPORT=" WHERE JIReportJob.label LIKE '%$@%'"
fi

mysql -h 127.0.0.1 -P 13306 -u root -p$(awk '/database_root/ {print $2}' /opt/opsview/deploy/etc/user_secrets.yml) -t jasperserver <<EOF | sed 's/| *$//g'
SELECT JIReportJob.label AS "Scheduled Report",
       JIReportJobParameter.parameter_name AS "Parameter Name",
       left(JIReportJobParameter.parameter_value, 80) AS "Parameter Value"
FROM JIReportJob
JOIN JIReportJobParameter ON JIReportJob.id = JIReportJobParameter.job_id${REPORT};
EOF