Queries with not exists condition

[akhilraj]

Hi,

Is there any query available for not exists condition.

We need to find list of pages whose cq:lastModified property is not available.

I tried with  below but it seems not proper.

path=/content/hr/stock/ubs
1_property=@jcr:content/cq:lastModified
1_property.operation=not exists
p.limit= -1

[spidey1405 · Accepted solution]

Try this:

path=/content/hr/stock/ubs
1_property=@jcr:content/cq:lastModified
1_property.operation=exists
1_property.value=false
p.limit= -1

property.operation can take one of the following values while using the property predicate evaluator.

1. equals for an exact match.
2. unequals
3. like partial matching
4. not for no match
5. exists for existence match

In your case to search for all nodes where  the property `@jcr:content/cq:lastModified` doesn't exist.

[akhilraj]

Thank you so much.

A slight change to get proper result.

We have to add type=cq:Page to get proper result.

path=/content/hr/stock/ubs
type=cq:Page
1_property=@jcr:content/cq:lastModified
1_property.operation=exists
1_property.value=false
p.limit= -1