Crud: Laravel backpack Search

[sandeepchowdary7]

Hello guys, I'm using Laravel backpack in my project. I’m trying to enable the case-insensitive search functionality. here is my code
$this->crud->addColumn([ 'name' => 'name', 'label' => 'name', 'searchLogic' => function ($query, $column, $searchTerm) { $query->orWhere('name', 'like', '%'.$searchTerm.'%'); } ]);
somehow it is not working as expected. any help that would be great. Thanks!

[sandeepchowdary7]

Fixed. NVM

[brynnb]

@sandeepchowdary7 This is the first result for this issue - might be helpful for future people if you included what the fix was :)

[sandeepchowdary7]

@brynnb here is the fix

$this->crud->addColumn([
           'name' => 'name',
           'label' => 'name',
           'searchLogic' => function ($query, $column, $searchTerm) {
               $query->orWhere('name', 'ilike', '%'.$searchTerm.'%');
           }
       ]);

Cheers! :)

[brynnb]

Thanks Sandeep! Additionally I found in another result that the issue is sometimes the database collation - apparently some are case sensitive and others aren't. I believe this was the issue for me (two identical sites deployed on two different databases - MySQL and Postgres - and one was being case sensitive and the other wasn't).

[sandeepchowdary7]

@brynnb I'm using Postgres DB. The above code was fixed my problem.

[brynnb]

It's a good solution for postgres, but it will throw 500 errors if using MySQL which doesn't have "ilike". For a project like mine that may be deployed on a variety of databases, this wouldn't work - but using the migrations to ensure the collation for columns is case insensitive will work regardless of database.

Thanks again!

[tabacitu]

Thanks for sharing your solution @sandeepchowdary7 !