This activity reads a report and saves the result(s) into a process Variable. The report must already exist within Appian.
One way to conserve the memory used by your processes is to collect any data or statistics that you might want to preserve using a report that is run by the Execute Process Report smart service in a sub-process. This allows you to completely delete the parent process upon (or shortly after) completion, while retaining any archival data you need to keep.
The user running the smart service must have at least Viewer rights to the process report. Attempting to complete this task without the proper user rights generates an error message for the process administrator and pauses the process.
Assignment Options: Unattended
After dragging and dropping the smart service on your canvas, double-click it to configure its properties for each tab listed below.
The General Tab allows you to name and describe the activity.
See also: General Node Properties
Report: Select a saved report (
.arf) from the system. If the user who creates a report saves it into the default My Reports location, other users cannot view it. The System Reports folder is located in the Appian Collaboration Center > Default Community > System Knowledge Center.
Max Rows: Specify the number of rows to return from the report. If you think of a report returned from this smart service as a single page of a process report, this setting is similar to the Rows Per Page setting on the Display tab of the Report Options dialog box. Having a value that surpasses the total number of rows in the report does not affect the report performance.
Context: (Optional) When a process instance is defined for the selected report's context, you can type the process ID of a new process instance context to use for the report, or you can use an expression to select the desired context.
Additional Filters: If the report is a process report (such as the Default Process Optimization Metrics report) this group box is displayed for you to add another by entering values for the following:
For example, if your report includes a list of office locations and staff, you might want to filter the report to only display office locations that include more than 50 staff members. Assuming that the staff column in your process report lists the number of people in each location.You would select the Staff column from the Column list; select >= from the Operator list; and type "50" in the Value field.
When you add another filter, the system applies the filter to the underlying analytics query before loading the report.
Select the Outputs Tab. Each column returned by the report is displayed as an entry on the node outputs list. Select the node output that contains the data you want to save into a process variable. The Result Properties are displayed. If your report saves multiple data values into a single cell (the intersection of a row and a column) only the first element is saved.
Select one of the following operators for saving your data.
Select an existing process variable from the Target list, or click to create a new process variable.
If you need to use an expression to modify your report data before saving it into a process variable, you can create a custom output. Each of the report columns are listed under Activity Class Parameters on the Data Tab of the Expression Editor.
You can configure the activity so that it only starts after certain time-period has lapsed since the last activity completed, or start it according to a fixed calendar schedule. You can also set repeated execution for the activity.
See also: Scheduling the Start of an Activity
This activity can only be run automatically (unattended). You can opt to run the activity as the process initiator or the process designer.