QueryBuilder case sensitive issue | Community
Skip to main content
saibul
Level 4
Oct 14, 2019 5:19 AM UTC
Solved

QueryBuilder case sensitive issue

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.
saibul
saibulAccepted solution
Level 4
Oct 21, 2019 8:12 AM UTC

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
Level 4
Oct 21, 2019 8:12 AM UTC

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.

Translate
Ankur_Khare
New Participant
Oct 16, 2019 5:48 AM UTC

Is it resolved?

Translate
Ankur_Khare
New Participant
Oct 15, 2019 7:49 AM UTC

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

Translate
Ankur_Khare
New Participant
Oct 15, 2019 3:01 AM UTC

Its working fine for me as well on 6.3.

Couldnt check on 6.5.

Translate
saibul
saibulAuthor
Level 4
Oct 15, 2019 2:43 AM UTC

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

Translate
Ankur_Khare
New Participant
Oct 14, 2019 6:59 AM UTC

Hi saibul​,

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

Regards

Translate