querybuilder question: return pages with a component which has a specific custom property value?

Question

Hi, is there a way to return URLS for pages which have a component with a property of a specific value?

E.g. if there are say 1000 games, and each has an overview page, and each of these pages has a game overview component which has a game ID and game name property.

The client website has a list of recently played game ids, and needs to load some thumbnails which are aspects of the games overview page.

Suraj_Kamdi · Accepted Answer

@tb3dock

Use the following query builder query to get desired output

path=/content/game
property=sling:resourceType
property.value=sample/components/structure/game-overview
group.1_property=gameId
group.1_property.value=0 (Optional)
group.2_property=gameName
group.2_property.value=0 (Otional)
group.p.and=true
p.limit=-1

I am considering all the possible scenarios here as per provided description.

Sanket_Kumbharkhane · Answer

@tb3dock Yes, please use the query builder tool "/libs/cq/search/content/querydebug.html" to get the results with the help of the below query

Search for specific property :

path=/content/my-project

type=nt:unstructured

property=gameid

property.value=gameid-value

p.limit=-1

Search for property exist

path=/content/my-project

property=gameid

property.operation=exists

property.value=true

p.limit=-1

OR with SQL2 :

All nodes where a property contains some String OR Value

SELECT * FROM [nt:unstructured] AS node

WHERE ISDESCENDANTNODE(node, "/search/in/path")

AND CONTAINS([propertyName], "someString")

Thanks,

Sanket

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded