Query JCR to fetch pages based on some conditions

Is there anything unique for this component?

if yes then use that property in your search query or you can use sling:resourceType property with the default value of your component i.e. /apps/abc/components/xyz. then it will return the result with all nodes having this property. ex - 

/content/geometrixx-outdoors/en/activities/nairobi-runners-running/jcr:content/par/product_reference_5b 

Iterate this result set &  split each URL on the basic of /jcr:content then first part will be the page URL.

type=nt:unstructured
path=/content/xyz
1_property=cq:commerceType
1_property.operation=exists
2_property=productData
2_property.operation=exists
3_property=cq:isCancelledForChildren
3_property.operation=exists

I am using this query for finding all nt:unstructured node having properties "cq:commerceType, productData, cq:isCancelledForChildren". this query is working fine and returns expected result. If you are not able to find it working then do the debugging by using one by one condition & check results.

Hi Ankur,

Thank you for your reply.

I added sling:resourceType property and the modified query as below, But still it doesnt seem to be working.

path=/content/xxx/xx/xx
type=nt:unstructured
1_property=sling:resourceType
1_property.value=x/x/x/x/x
2_property=abcd
2_property.operation=exists
3_property=efgh
3_property.operation=exists
4_property=ijkl
4_property.operation=exists
p.limit=-1

Your thoughts on this will be really helpful.

Hi Ankur,

Thank you for your reply.

The query is working fine for me. But the problem is I want to find only pages which has a specific component which has these properties.
There are many components with same properties and I do not want those to come up in results.

Hi

Could you elaborate what sort of result you get? Too much? Not at all?
How much time does it take to the query to render the results?

Hi Carlino,

Nope, It did not throw up any results.