Hello Chrish,
You find the Workflow Activities in the "wf_activity" table.
In the column "variables", the values of the WF Activity properties are stored but we can't create report on this.
I have alternate solution is that, I have created background script. It will export all data in excel file.
Script -
var output = "Workflow Name,Activity Name,Approval Groups"; //header for csv file
var table = "wf_activity";
var recordId = ""; //using for attachment fill
var gr = new GlideRecord(table);
gr.addEncodedQuery("activity_definition.nameSTARTSWITHApproval - Group");
gr.query();
var count = 0;
while (gr.next()) {
count++;
output += "\n" + gr.workflow_version.getDisplayValue() + "," + gr.name + "," + gr.vars.groups.getDisplayValue();
if (!recordId) {
recordId = gr.sys_id;
}
}
gs.print(recordId);
writeAttachmentFile(output);
function writeAttachmentFile(data) {
var attachment = new Attachment();
var attachmentRec = attachment.write(table, recordId, "WFGroupApproval.csv", "text/csv", data);
}Note - I run the Query on the WF Activity with the "Approval - Group".
Excel data looks like -
If my answer helped you in any way, please then mark it as helpful.
Kind regards,
Akshay Kangankar
