Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
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?