Client search is searching only from the starting string

Versione 1.5.2

The search in my installation is working only with the start string characters.

If the client name is:

Google Inc.

I can find it only searching “Goo” and not searching “Inc” or “gle”.

Within following file:
/application/modules/clients/controllers/Ajax.php

Replace these occurencies:
LIKE \'' . $escapedQuery . '%\'')

to this:
LIKE \'%' . $escapedQuery . '%\'')

There are 3 occurences in total (line 40 + 41 + 42)

@FooLab @Kovah

2 Likes

it’s working now - confirmed

please create a pull request here Pull requests · InvoicePlane/InvoicePlane · GitHub

thank you