Querybuilder in AEM 6.2 returning different result than AEM6.0 | Community
Skip to main content
Dterner
Dterner
Level 2
Feb 13, 2017 8:04 PM UTC
Solved

Querybuilder in AEM 6.2 returning different result than AEM6.0

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.
Dterner
DternerAccepted solution
Level 2
Jun 23, 2017 11:03 AM UTC

we ended up rewriting the query in sql2 notation.

View reply

4 replies

smacdonald2008
smacdonald2008
Level 10
Jun 23, 2017 2:34 PM UTC

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

Translate
Dterner
DternerAuthorAccepted solution
Level 2
Jun 23, 2017 11:03 AM UTC

we ended up rewriting the query in sql2 notation.

Translate
Punith_Shetty
Level 2
Jun 22, 2017 11:14 PM UTC

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

Thanks

Punith

Translate
Dterner
DternerAuthor
Level 2
Feb 13, 2017 8:21 PM UTC

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

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

Translate
Terms & ConditionsAccessibility statement

Loading footer...