Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

QueryBuilder case sensitive issue

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Level 4

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.

View solution in original post

6 Replies

Avatar

Community Advisor

Hi saibul​,

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

Regards

Avatar

Level 4

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

Avatar

Community Advisor

Its working fine for me as well on 6.3.

Couldnt check on 6.5.

Avatar

Community Advisor

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

1844722_pastedImage_1.png1844721_pastedImage_0.png

Avatar

Correct answer by
Level 4

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.