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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
Thank you @DEBAL_DAS that really helped
Views
Likes
Replies
Views
Likes
Replies