AEM Querybuilder find workflow based on the payload path | Community
Skip to main content
May 12, 2023
Solved

AEM Querybuilder find workflow based on the payload path

  • May 12, 2023
  • 1 reply
  • 916 views

I have tried below query but didn't work. The one I am struggle with is the bold part:

 

path=/var/workflow/instances/server0
type=cq:Workflow
1_property=modelId
1_property.value=/var/workflow/models/wpsm/workflowModelName
2_property=JCR_PATH
2_property.value=/content/main/en/commissioner-2/calendar/food-distribution----first-christian-church
p.limit=-1

 

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 rawvarun

2_property has type= cq:Payload instead of cq:Workflow , so the query will not return results.

So, the above query cannot run with two properties.

It will run independently as properties are stored in different type:

path=/var/workflow/instances/server0 type=cq:Workflow 1_property=modelId 1_property.value=/var/workflow/models/wpsm/workflowModelName p.limit=-1path=/var/workflow/instances/server0 type=cq:payload 2_property=JCR_PATH 2_property.value=/content/main/en/commissioner-2/calendar/food-distribution----first-christian-church p.limit=-1

 

1 reply

rawvarun
Community Advisor
rawvarunCommunity AdvisorAccepted solution
Community Advisor
May 12, 2023

2_property has type= cq:Payload instead of cq:Workflow , so the query will not return results.

So, the above query cannot run with two properties.

It will run independently as properties are stored in different type:

path=/var/workflow/instances/server0 type=cq:Workflow 1_property=modelId 1_property.value=/var/workflow/models/wpsm/workflowModelName p.limit=-1path=/var/workflow/instances/server0 type=cq:payload 2_property=JCR_PATH 2_property.value=/content/main/en/commissioner-2/calendar/food-distribution----first-christian-church p.limit=-1

 

May 15, 2023

I updated the property value from JCR_PATH to path, and now it gives me the result. 

path=/var/workflow/instances/server0
type=cq:payload
2_property=path
2_property.value=/content/main/en/commissioner-2/calendar/food-distribution----first-christian-church
p.limit=-1

 

So is there a way to query nodes based on payload as well as the cq:workflow properties, such as workflow model, startTime and status, etc?