Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

AEM Querybuilder find workflow based on the payload path

Avatar

Level 1

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

 

payload.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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=-1
path=/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

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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=-1
path=/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

 

Avatar

Level 2

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?