Full text search

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mgielda
    Junior Member
    • May 2015
    • 8

    Full text search

    Hi,
    It's me again - I just noticed that all searches in Espo only search entities which start with the search string, and was wondering if it is possible ro do a full text search? Often tasks are named after e.g. a company (for example: arrange a meeting with XYZ), and the company name (XYZ) cannot be used to search the tasks to find the one you are looking for. This is a fairly common use case I believe?

    Could full text search be activated somehow or is it a not-yet-implemented feature?

    Best regards,
    Michael
  • yuri
    Member
    • Mar 2014
    • 8501

    #2
    Hi

    You can prepend '%' to your search phrase. It's made for a sake of performance.
    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

    • mgielda
      Junior Member
      • May 2015
      • 8

      #3
      Thank you very much, you are most helpful. Indeed, this works very well.

      Cheers,
      Michael

      Comment

      • lamvnd
        Junior Member
        • May 2015
        • 17

        #4
        Originally posted by yurikuzn
        Hi

        You can prepend '%' to your search phrase. It's made for a sake of performance.
        How to do that as default?

        Comment

        • yuri
          Member
          • Mar 2014
          • 8501

          #5
          application/Espo/Core/SelectManagers/Base.php

          find the needed line and prepend % there.
          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

          • emillod
            Active Community Member
            • Apr 2017
            • 1404

            #6
            Can you tell me in which line i need to put % ?

            Comment

            • peterberlin
              Active Community Member
              • Mar 2015
              • 1004

              #7
              If you can turn % on and off, everyone can decide for themselves if he likes the performance.
              Peter

              Comment

              Working...