Need to get the last subjected date for the workflow using AEM querybuilder

Avatar

Avatar

samsundar23

Avatar

samsundar23

samsundar23

09-12-2020

I'm using AEM 6.5.
I want to get the start date as a result when was the last time the particular workflow is subjected using aem query builder.

I tried multiple queries which was not giving the result needed for me. I mean the last time the workflow is used.

I tired below query which was not giving me the expected result;

path=/var/workflow/instances/server0
type=cq:Workflow
1_property=status
1_property.value=COMPLETED
2_property=modelId
2_property.value=/var/workflow/models/test_author/netbank/publish-topcat-content
p.limit=-1

 

Kindly do pour in your thoughts so that I do get my desired result as outcome.

Thanks in advance !

AEM aem6.5 querybuilder

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Arun_Patidar

MVP

Total Posts

3.1K

Likes

1.2K

Correct Reply

883

Avatar

Arun_Patidar

MVP

Total Posts

3.1K

Likes

1.2K

Correct Reply

883
Arun_Patidar
MVP

09-12-2020

Hi,

Your query looks fine. I am getting the results as expected. PFA.

 

{"success":true,"results":1,"total":1,"more":false,"offset":0,"hits":[{"jcr:path":"/var/workflow/instances/server0/2020-12-09/request_for_activation_1","startTime":"Wed Dec 09 2020 19:35:28 GMT+0100"}]}

 

Screenshot 2020-12-09 at 7.40.47 PM.png

Answers (1)

Answers (1)

Avatar

Avatar

Vijayalakshmi_S

MVP

Avatar

Vijayalakshmi_S

MVP

Vijayalakshmi_S
MVP

09-12-2020

Hi @samsundar23,

Cross check the workflow related entries are available in the path we are querying for(/var/workflow/instances/..) in CRXDE at first place. 

If yes, then cross check if you have permissions for the path or can quickly cross verify by executing the query by being in admin login.