Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Search query not working after AEM 6.5 upgrade


Level 3

Hi Everyone,


We have recently upgraded from AEM 6.2 to 6.5. When we tested the search functionality, we encountered that few of our queries are not executing and throwing an error.


I am pasting one query here for reference : 

select [jcr:path], [jcr:score], [rep:excerpt] from [nt:hierarchyNode] as a where isdescendantnode(a, '/content') and [jcr:content/hideFromSearch] is null and contains([jcr:content/*], 'Media')


Error we can see in logs and on query performance tool is : 

Screen Shot 2020-12-16 at 8.52.00 PM.png


If we change some predicate like below the query works : 

select [jcr:path], [jcr:score], [rep:excerpt] from [nt:hierarchyNode] as a where isdescendantnode(a, '/content') and [jcr:content/hideFromSearch] = 'false' and contains([jcr:content/*], 'Media')


0 Replies


Community Advisor

Looks like some structural changes on AEM 6.5. We've faced similar issues (not same as below) and modifying the predicates to fix these issues.





Level 3
But when I execute the same query on plain vanilla AEM 6.5 instance it works fine(doesn't throw any error)


Level 3
I tried executing the query on 6.5.6 as well and it worked fine. Can you please let me know what issue you see in predicates?