Query Builder AEM 6.5: does not contain predicate | Community

Level 4

Solved

Query Builder AEM 6.5: does not contain predicate

Forum|Forum|3 years ago
September 23, 2022
1 reply
1724 views

Hi everyone, so when I need to add a query for contains I use like operation as shown below:

```

type=nt:unstructured
path=/content/dam/en/articles
nodename=master
orderby=@title
p.limit=0
p.skip=0
p.hits=selective
p.properties=jcr:path
property=primaryCategoryTag
property.value=%rally%
property.operation=like

```

However I have a use case where I need to do contains not, can someone help me to do the same? Is there any operation as `unlike`? Which helps me pick all those entities which doesn't contain the given text?

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 arunpatidar

I think this is not possible with QueryBuilder , you can create your own predicate e.g.

https://github.com/arunpatidar02/aem63app-repo/blob/master/java/CaseInsensitiveLikePredicate.java

or use SQL2

Community Advisor

Accepted solution

Community Advisor

I think this is not possible with QueryBuilder , you can create your own predicate e.g.

https://github.com/arunpatidar02/aem63app-repo/blob/master/java/CaseInsensitiveLikePredicate.java

or use SQL2

Arun Patidar

spidey1405Author

Level 4

If lets say I want to deploy these to AEM cloud locally, where am I supposed to add these files? Predicates that I create?

Community Advisor

Community Advisor

This is a java code, you have to deploy via code module.

Arun Patidar