Need to get the last subjected date for the workflow using AEM querybuilder | Community
Skip to main content
samsundar23
samsundar23
New Participant
December 9, 2020
Solved

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

  • December 9, 2020
  • 2 replies
  • 2691 views

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 !

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 arunpatidar

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"}]}

 

2 replies

Vijayalakshmi_S
Vijayalakshmi_S
New Participant
December 9, 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.

    arunpatidar
    arunpatidarAccepted solution
    New Participant
    December 9, 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"}]}

     

    Arun Patidar
      samsundar23
      samsundar23Author
      New Participant
      December 10, 2020

      Hi @arunpatidar ,

       

      Thanks for your inputs.

      I want to get start date as a result for the query executed.

      For instance, if page-name-change is the custom workflow for which I want to get last time this workflow is subjected in AEM author instance.
      Kindly let me know the way.

       

      Thanks

      SHYAMSUNDAR TK

       

       

      Terms & ConditionsAccessibility statement

      Loading footer...