AEM Query for property with no value | Community
Skip to main content
Shubham_borole
New Participant
June 9, 2017
Solved

AEM Query for property with no value

  • June 9, 2017
  • 11 replies
  • 19586 views

I am looking for writing an AEM query using the Query Builder Debugger. My goal is to look for nodes with property "sectionEmail" and value as blank () No Value. I tried something like this below

path=/content/myproject

type=cq:Page

property=sectionEmail

property.value=

As a result I just get all the nodes with the property "sectionEmail" regardless of whther it has a value or not.

Any idea on corrections needed to make on this?

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by VeenaVikraman

The solution I was suggesting is to get all the nodes with the property=sectionEmail  and then once you have those , iterate over the property nodes and look for the nodes which has empty value .

Thanks

Veena

11 replies

New Participant
June 9, 2017

You can do the following and remove the property.value

property.operator=not

You may also need to add @jcr:content/ to the property name, so the full thing would look like this:

path=/content/myproject 

type=cq:Page 

property=@jcr:content/sectionEmail 

property.operation=not