Query to find missing property in page hirearchy [Query Builder] AEMasCloud

[TushaarSrivastava]

Hi Team,
I need help to write a query in query builder to find the missing property.

For example we have a 100 number of pages under home page [/content/project/us/en/home]. and we are setting a property pageType under every page property for exmaple setting pageType and storing under [/content/nexxus/gb/en/home/jcr:content] {pageType [String] somevalue}.

We have to write a query to find the pages in which we don't have or missing pageType property.

Thanks

@kautuk_sahni  @Vijayalakshmi_S  @arunpatidar  @Theo_Pendle 

[DEBAL_DAS · Accepted solution]

We need to use below predicate -

property.operation=not

check if property does not exists

https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md

Let's assume I want to identify pages those doesn't have cq:lastReplicationAction property and here is the query -

path=/content/we-retail/language-masters/en
type=cq:Page
1_property=jcr:content/cq:lastReplicationAction
1_property.operation=not
p.limit=-1

[TushaarSrivastava]

Thank you @DEBAL_DAS  that really helped 🙂