AEM6.3 - QueryBuilder - filter by properties that contains some string

Question

Hi,We are using QueryBuilder to do the search on our website.We have a list of vanitys url's stored on a property called sling:vanityPath that is a multivalued property.I want to put on the search criteria a restriction to search pages that contains some string on the vanity urls.For example:search pages that contains "en_us" on the property sling:vanityPath (that is a multivalued property).Is it posible to do something like this?I could not found anything similar on the internet, I appreciate any help.Thank you very much in advance.

arunpatidar · Accepted Answer

Are you using SQL2? if yes, you can use below query

SELECT parent.* FROM [cq:Page] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '/content') AND child.[sling:vanityPath] IS NOT NULL

you can use child.[sling:vanityPath] LIKE 'en_us' also

if you are using Query Builder Debugger Tool, you can write like below:

type=nt:base

path:/content/

property:jcr:content/sling:vanityPath

property.operation:exists

you can use other property operation also e.g. "like" to search for particular keyword for vanity urls in properties

elizabethp60981 · Answer

Hi,It works!Thank you very much for the help!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded