Get all the workflows triggered for a payload (asset path)

[Alvaro_C_]

Hello,

Is there any way to get all the workflow instances launched for a payload (e.g. /content/dam/assets/weddingPictures/party1.jpg).

The two only methods that I can guess are:

• Invoke http://localhost:4502/etc/workflow/instances.json  and iterate for every instance and make a new request  in order to get the payload. Then filter all the instances that were not launched under ...party1.jpg. I have tested it, but it does not work as we get the next message: The query read or traversed more than 3000 nodes. To avoid affecting other tasks, processing was stopped. I've checked the documentation at Interacting with Workflows Programmatically but I have not found a way to paginate.
• Invoke http://localhost:4502/mnt/overlay/cq/workflow/admin/console/content/archive//jcr:content/views/list....  and filter all the instances that were not launched under ...party1.jpg. Althoug it allows me to paginate, I have to perform an unknown number of requests.

Regards.

[smacdonald2008]

Typically you invoke a workflow for a specific asset.

[mjb54261515]

Yes we invoke workflow for an asset and In that thread we can get All WorkItems assigned to an active Workflow instance and the respective user of the WorkflowSession .

WorkItem[] workItems = wfSession.getActiveWorkItems();

[Alvaro_C_]

Hello,

This discussion is more related to stats on workflows. Actually I'm not interested on the ones that are currently running but on the past activity. The kind of queries I would like to answer are:

• Which are the content path with more workflow activity during the last month?
• Which workflows were triggered under path X between January and April?
• Which are the most widely used workflows?
• etc.

On the other hand, just comment that in our production environment every asset can be modified dozens of times by different workflows during its life-cycle.

Regards.

[mjb54261515 · Accepted solution]

OK got you.

For getting those result OOB provides a servlet path with some basic parameters like (start,limit)

http://localhost:4502/libs/cq/workflow/content/console/archive.json?_dc=1511371717582&start=0&limit=...

each result object

{

item: "/etc/workflow/instances/server0/2017-11-22/update_asset_3",

state: "COMPLETED",

initiator: "*",

launcherUser: "admin",

startTime: 1511366004403,

endTime: 1511366004826,

model: "DAM Update Asset",

modelVersion: "1.1",

payload: "/content/dam/*/*/*/jcr:content/renditions/original",

comment: "",

title: ""

}

if you want you can overlay this functionality or create a new servlet with your custom script according to your use case

To start on pls take a lookt at

/libs/cq/workflow/content/console/archive

and code in /libs/cq/workflow/components/console/archive/json.jsp

json.jsp has already some working apis in it

Hope this helps

~Manoj

[Alvaro_C_]

Many thanks!

That's the pointer I was looking for.

Regards.