Applicable Versions: 5.50.0073 Onwards
You may wish to control the refreshing of data in a dashboard from a Progress batch process, to say update the data overnight. In order to achieve this, you cannot use the dashboard control as it is a visual control which cannot be rendered in a batch process.
A procedure that will open and refresh all the queries in a dashboard can be downloaded at the below.
The parameters for the procedure are described below:
|ipFileName||CHARACTER||A character input parameter that should contain the fully qualified path to the dashboard file.|
|sLogFile||CHARACTER||A character input parameter that defines a log file to log the process. The log file can grow very rapidly, so only use this option to debug a problem. By default, pass in a blank string which will turn logging off.|
|sUsername||CHARACTER||A character input parameter that defines a username required to log in to DataPA OpenAnalytics. If not required, pass in a blank string.|
|sPassword||CHARACTER||A character input parameter that defines a password used to log in to DataPA OpenAnalytics. If not required, pass in a blank string.|
|opSuccess||LOGICAL||A logical output value that if true, indicates the procedure completed OK.|
|opError||CHARACTER||A character output parameter that indicates why the procedure did not complete OK.|
For example the following procedure will all queries in a test dashboard...
DEFINE VARIABLE opSuccess AS LOGICAL NO-UNDO.
DEFINE VARIABLE opError AS CHARACTER NO-UNDO.
THEN MESSAGE "Refresh Succeeded" VIEW-AS ALERT-BOX.
ELSE MESSAGE "Refresh Failed: " + opError VIEW-AS ALERT-BOX.