Expand my Community achievements bar.

SOLVED

Querybuilder in AEM 6.2 returning different result than AEM6.0

Avatar

Level 2

We are working on moving some projects from AEM 6.0 and 6.2 one of the applications has an error and documentation hasn't been helpful.her is the reduced case querybuilder query

type=cq:page path=/content/nera/en/experts p.hits=full p.nodedepth=1 1_property.opertaion=like 1_property=jcr:content/jcr:title 1_property.value=Dr.

The issue is that even though the operation is set to like only full matches are returned. partial matches return no results however on AEM 6.0 partial results are returned. In my case the value of "Dr." returns nothing while Dr. Lawrence Wu which is an existing node returns the page.

Any help appreciated

1 Accepted Solution

Avatar

Correct answer by
Level 2

we ended up rewriting the query in sql2 notation.

View solution in original post

4 Replies

Avatar

Level 2

Also, I did use a wildcard in the last line with the same result:

So the last line would be : 1_property.value=%Dr.%

Avatar

Level 2

Looks like I am facing a similar issue. Did you find a solution to it?

Thanks

Punith

Avatar

Correct answer by
Level 2

we ended up rewriting the query in sql2 notation.

Avatar

Level 10

I am checking with the AEM team to see if this is normal for that AEM version.