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.X.Y.html 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.

Level 2

Solved

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

Forum|Forum|8 years ago
November 22, 2017
5 replies
4504 views

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.X.Y.html 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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by manoj_devapath

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=40

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

smacdonald2008

Level 10

Typically you invoke a workflow for a specific asset.

manoj_devapath

Level 5

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();

A

Alvaro_C_Author

Level 2

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.

manoj_devapathAccepted solution

Level 5

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=40

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

A

Alvaro_C_Author

Level 2

Many thanks!

That's the pointer I was looking for.

Regards.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded