QueryBuilder case sensitive issue | Community
Skip to main content
saibul
New Participant
October 14, 2019
Solved

QueryBuilder case sensitive issue

  • October 14, 2019
  • 6 replies
  • 3405 views

I have a file under /content/dam/custom/fileA.jpg

If I give exact filename including case then it returns the result in QueryBuilder, if I give fulltext=filea.jpg then it is not returning any result in QueryBuilder.

type=dam:Asset

path=/content/dam/

fulltext=fileA.jpg

It is recently migrated(InPlace migration) from AEM 6.3 to 6.5

Is there a configuration to enable/disable the case insensitive in fulltext search?

kindly suggest me if any configuration to enable case insensitive in fulltext search.

Environment details:

AEM-6.5.1

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 saibul

Thank you very much @ka786 for your effort to solve an issue, In plain 6.5 servers it works perfectly. We did migration from 6.3 to 6.5, the crx it contains the node "/oak:index/damAssetLucene/analyzers". if I remove the node "analyzers" node under "/oak:index/damAssetLucene/" it works perfectly. I am not sure what exactly makes this work by adding and removing these nodes and going to study as well. please reply if anyone knows about this.

6 replies

saibul
saibulAuthorAccepted solution
New Participant
October 21, 2019

Thank you very much @ka786 for your effort to solve an issue, In plain 6.5 servers it works perfectly. We did migration from 6.3 to 6.5, the crx it contains the node "/oak:index/damAssetLucene/analyzers". if I remove the node "analyzers" node under "/oak:index/damAssetLucene/" it works perfectly. I am not sure what exactly makes this work by adding and removing these nodes and going to study as well. please reply if anyone knows about this.

Ankur_Khare
New Participant
October 16, 2019

Is it resolved?

Ankur_Khare
New Participant
October 15, 2019

Hi Saibul,

Tried on 6.5.2 without any custom code deployed on this server  query is working fine as below-

type=dam:Asset

path=/content/dam/we-retail-screens

fulltext=TEST.png

Ankur_Khare
New Participant
October 15, 2019

Its working fine for me as well on 6.3.

Couldnt check on 6.5.

saibul
saibulAuthor
New Participant
October 15, 2019

thanks for your reply. no luck on orderby.case property and I hope this property is for sorting the result with case insensitive.

Ankur_Khare
New Participant
October 14, 2019

Hi saibul​,

Did you try orderby.case: support case insensitive orderby.case=ignore.

Regards