Announcement

Collapse
No announcement yet.

Problem with search

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with search

    Hi!
    I have a problem with searching in espo.
    I have a database with about 5000 accounts. When I search an account's name it doesn't gives me the result.
    For example, lets say that I have a client with name (in one field) "Doe John". When I search for "Doe" or "Doe John" there is no problem. When I search for all clients named "John" it displays some but not all of them and definitely not Doe John.
    I searched in log files but I didn't find anything relative.
    Can anyone help in this?

    Thanks in advance
    Vasilis

  • #2
    Hello

    Use '%' before -> '%John'
    By default it searches like "starts with", it is equals sql-language " LIKE '{input_text}%' ".

    Comment


    • #3
      Thank you Tanya!
      It worked fine

      Comment


      • #4
        Can we have this % on by default?
        Without it, search is not as valuable.

        Comment


        • #5
          To enable '%<term>%' support in all the search boxes add

          'textFilterUseContainsForVarchar' => true

          to your data/config.php file.

          Comment


          • #6
            It works fine, if I enter a Minimum of 4 characters. It does not work for 3 characters (e.g. search for FTP).

            Is it possible to set the minimum to 3 characters?

            Thanks in advance

            Sven

            Comment


            • #7
              Hello
              global core - https://github.com/espocrm/espocrm/b...s/Base.php#L65
              any modification is not upgrade save

              if you need it for specified entity, better is to override entity SelectManager and define this const as 3
              (https://forum.espocrm.com/forum/deve...m-field-values)

              Comment

              Working...
              X