The search panel is not working properly

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Laimonas
    Senior Member
    • May 2021
    • 201

    The search panel is not working properly

    When the check box "Use 'contains' operator when filtering varchar fields" (Administration -> Settings -> Search) is checked - it supposes to work as the "contains" operator.

    However, if I type less than 4 symbols in the Search panel, the search comes up with no results (there are many three-letter words that I cannot find using just the Search panel).

    'Contains' operator and the "%%" sign are not sensitive to the number of symbols, I can type one, two, three, or more symbols - the search finds all records containing these symbols (but it's not that comfortable to use them).

    It would be great if the Search panel would not be limited to typing a minimum of 4 symbols.

    Please find the pictures attached.
    Attached Files
  • esforim
    Active Community Member
    • Jan 2020
    • 2204

    #2
    I believe that setting only applies to "Global" search, not entity search.

    You can try to enable in the "Full Search" /#Admin/entityManager/ edit button and see if that help.

    I can't remember if I need to change anything but I can search for single character, 2 chars, 3 chars without having to use the minimum 4 chars. Although the result is quite rubbish when you using <2 chars though but it work.

    I don't remember I need to do this, https://forum.espocrm.com/forum/deve...h-js#post70782

    From what I remember all I need was enable Full Search, clear cache and rebuild.

    Comment

  • yuri
    Member
    • Mar 2014
    • 8511

    #3
    Not a bug.

    You can change a config param:

    https://docs.espocrm.com/administrat...s/#text-search
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • Laimonas
      Senior Member
      • May 2021
      • 201

      #4
      I have added this param, now it works, thanks a lot!

      Comment

      Working...