Searching on field which has a numeric and string value in a STRING field

[Roydee]

Summary of problem or feature request

So i have a field titled 'default_due_date_label' in my database which carries data such as this:

• 9 Months Before
• 6 Months Before
• 7 Days Before
• etc etc

The 'default_due_date_label' is a STRING field.

Search 1: When I perform a search for example "6 Months Before" it does NOT return any results. Search 2: However if I search on "Months Before" it returns all results which has this search term.

It seems to leaving out the numeric value in Search 1.

Spend lots of hours on this so far and I am wondering if someone could help me out.

Code snippet of problem

While the code below should not be needed. I have also tried it.

->filterColumn('default_due_date_label', function ($query, $keyword) { // Perform a case-insensitive search for the entire keyword $query->whereRaw('LOWER(default_due_date_label) LIKE ?', ['%' . strtolower($keyword) . '%']); })

System details

• Operating System - Windows 10
• PHP Version 8.2
• Laravel Version 10 "yajra/laravel-datatables": "^10.0", "yajra/laravel-datatables-buttons": "^10.0",

[yajra]

It could be due to the multi-term search config. Try disabling it in the datatables.php config.

'multi_term' => false,

[Roydee]

Perfect... thats worked. Thanks so much.