Need to get the last subjected date for the workflow using AEM querybuilder | Community
Skip to main content
samsundar23
samsundar23
Level 4
Dec 9, 2020 3:38 PM UTC
Solved

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

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.
arunpatidar
arunpatidarAccepted solution
New Participant
Dec 9, 2020 6:43 PM UTC

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
View reply

6 replies

Vijayalakshmi_S
Vijayalakshmi_S
Level 10
Dec 9, 2020 9:07 PM UTC

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.

Translate
    arunpatidar
    arunpatidarAccepted solution
    New Participant
    Dec 9, 2020 6:43 PM UTC

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

     

    Translate
    Arun Patidar
      samsundar23
      samsundar23Author
      Level 4
      Dec 10, 2020 7:09 AM UTC

      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

       

       

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...