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 : If
we change some pred...