Querybuilder in AEM 6.2 returning different result than AEM6.0 | Community
Skip to main content
Dterner
Level 2
February 13, 2017
Solved

Querybuilder in AEM 6.2 returning different result than AEM6.0

  • February 13, 2017
  • 4 replies
  • 1872 views

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

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 Dterner

we ended up rewriting the query in sql2 notation.

4 replies

Dterner
DternerAuthor
Level 2
February 13, 2017

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

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

Level 2
June 22, 2017

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

Thanks

Punith

Dterner
DternerAuthorAccepted solution
Level 2
June 23, 2017

we ended up rewriting the query in sql2 notation.

smacdonald2008
Level 10
June 23, 2017

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