[Bug] filterColumn does not work on individual column search

[yajra]

as reported by @sameerpanjwani on issue #43

[sameerpanjwani]

Still doesn't work

public function getMultiFilterSelectData()
    {
        $users = User::select([  \DB::raw("CONCAT(users.id,'-',users.id) as user_id"), 'name', 'email', 'created_at', 'updated_at']);

        $dt =  Datatables::of($users);

        // Global search function
        if ($keyword = \Request::get('search')['value']) {
            // override users.name global search

            // override users.id global search - demo for concat
            $dt ->filterColumn('user_id', 'whereRaw', "CONCAT(users.id,'-',users.id) like ?", ["%$keyword%"]);
        }

        return $dt->make(true);
    }

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_id' in 'where clause' (SQL: select count() as aggregate from (select '1' as row_count from users where LOWER(user_id) LIKE %101%) count_row_table)*

[yajra]

It's because you are using global search and not column search. You should use something like below:

        $users = User::select([
            DB::raw("CONCAT(users.id,'-',users.id) as user_id"),
            'name',
            'email',
            'created_at',
            'updated_at']);
        $datatables = Datatables::of($users);

        $columns = $request->get('columns');
        foreach ($columns as $column) {
            if ($column['searchable'] == 'true' and $column['search']['value'] != '' and $column['name'] == 'user_id') {
                $datatables->filterColumn('user_id', 'whereRaw', "CONCAT(users.id,'-',users.id) like ?", ["%{$column['search']['value']}%"]);
            }
        }

        return $datatables->make(true);

On your code, filterColumn is not triggered.

[sameerpanjwani]

Oh ok, I didn't realize that. Sorry, my mistake.