Search query not working after AEM 6.5 upgrade | Community
Skip to main content
ashishkhadpe
ashishkhadpe
Level 3
December 16, 2020
Question

Search query not working after AEM 6.5 upgrade

  • December 16, 2020
  • 1 reply
  • 1767 views

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 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')

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Singaiah_Chintalapudi
Singaiah_Chintalapudi
Level 7
December 16, 2020

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.

 

Thanks,

Singaiah

    ashishkhadpe
    ashishkhadpeAuthor
    Level 3
    December 16, 2020
    But when I execute the same query on plain vanilla AEM 6.5 instance it works fine(doesn't throw any error)
    Terms & ConditionsAccessibility statement

    Loading footer...