Laravel DataTables change filters

Question

Could not find a solution how to override Laravel DataTables behaviour. I have a piece of code in front end:

var columnFilter = function(columnSelector, value) {
    $('.clear-filter').removeClass('active');
    clearFilter();
    table.column(columnSelector + ':name').search(value).draw();
    console.log(value);
}

The problem here is that it gives me a query with 'LIKE' :

 (where 'column' LIKE '%value%'.)

Is there a way to override this and use EQUALS instead of like?

Thank you.

Why don't you ask / search on the yajra-datatable repository or their documentation site yajrabox.com/docs/laravel-datatables? — Kyslik
– Kyslik, Commented Oct 11, 2018 at 8:58
I have read all the documentation few times (not only this one), however, no solution was found. — Arūnas Kiršis
– Arūnas Kiršis, Commented Oct 11, 2018 at 12:18

Tim M. · Accepted Answer · 2019-06-19 19:48:05Z

1

I found the filterColumn function to be where the query can be customized. For example:

return DataTables::eloquent($model)
            ->filterColumn('columName', function($query, $keyword) {
                $sql = "columnName = ?";
                $query->whereRaw($sql, [$keyword]);
            })
            ->toJson();

Ref. https://github.com/yajra/laravel-datatables-docs/blob/master/filter-column.md

answered Jun 19, 2019 at 19:48

Tim M.

1553 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arūnas Kiršis · Accepted Answer · 2018-10-11 12:20:21Z

0

Have not found a way to do it properately. However, managed to make workaround using regular expressions.

answered Oct 11, 2018 at 12:20

Arūnas Kiršis

1953 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel DataTables change filters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related