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

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

  • December 9, 2020
  • 2 replies
  • 2693 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

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
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
    Level 4
    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

     

     

    Vijayalakshmi_S
    Vijayalakshmi_S
    Level 10
    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.

      Terms & ConditionsAccessibility statement

      Loading footer...