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

QueryBuilder case sensitive issue

  • October 14, 2019
  • 6 replies
  • 3414 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

    Ankur_Khare
    Community Advisor
    Ankur_KhareCommunity Advisor
    Community Advisor
    October 14, 2019

    Hi saibul​,

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

    Regards

    saibul
    saibulAuthor
    Level 4
    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
    Community Advisor
    Ankur_KhareCommunity Advisor
    Community Advisor
    October 15, 2019

    Its working fine for me as well on 6.3.

    Couldnt check on 6.5.

    Ankur_Khare
    Community Advisor
    Ankur_KhareCommunity Advisor
    Community Advisor
    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
    Community Advisor
    Ankur_KhareCommunity Advisor
    Community Advisor
    October 16, 2019

    Is it resolved?

    saibul
    saibulAuthorAccepted solution
    Level 4
    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.

      Terms & ConditionsAccessibility statement

      Loading footer...