AEM query builder , not equals condition

[AnnzRoz]

I wanted to query all the pages with below conditions

1. should be activated pages
2. a property(flag) should be set to false
3. should exclude 3 templates (template a, template  b, template c)

I tried the below query for first 2 conditions, but how to include the third condition?

type=cq:PageContent
path=/content/retail
1_property=flag
1_property.value=false
2_property=cq:lastReplicationAction
2_property.value=Activate
property.and
p.limit=-1
p.hits=full

[arunpatidar · Accepted solution]

Try with below query

type=cq:PageContent
path=/content/retail
1_property=flag
1_property.value=false
2_property=cq:lastReplicationAction
2_property.value=Activate
property.and
group.property=cq:template
group.property.1_value=value1
group.property.2_value=value2
group.property.3_value=value3
group.property.operation=unequals
group.property.or
p.limit=-1
p.hits=full

[AnnzRoz]

The template check is not happening, should we try joing the first property and group?

[arunpatidar]

Try with group and query

type=cq:PageContent
path=/content/retail
1_property=flag
1_property.value=false
2_property=cq:lastReplicationAction
2_property.value=Activate
property.and
group.property=cq:template
group.property.1_value=value1
group.property.2_value=value2
group.property.3_value=value3
group.property.operation=unequals
group.property.and=true
p.limit=-1
p.hits=full

[AnnzRoz]

Thanks, this worked