laravel datatables search in addColumn

Question

I use laravel/datatables to list data.

I manipulated my datalist with addColumn function. However I am not able to use search in view for added columns. Because search is working according to database rows. Datatables works fine but in the view search area is not working. Because there isnt any fullname row in database table.

Here you can find my codes (I want to search for fullname but I can't)

Order Model

public function getFullname()
{
    return json_decode($this->getAttribute('delivery_adress'))->fullname;
}

OrderController.php

if ($request->ajax()) {
    return datatables()->of(Order::query())
        ->addColumn('fullname', function (Order $order) {
            return $order->getFullname();
        })->addColumn('city', function (Order $order) {
            return $order->getCity();
        })->addColumn('product_id', function (Order $order) {
            return $order->product->title;
        })->make(true);
}

Orders Blade / Datatables code

        "pageLength": 10,
        processing: true,
        serverSide: true,
        ajax: 'orders',
        columns: [
            { data: 'id', name: 'id'},
            { data: 'fullname', name: 'fullname', defaultContent: '-' , orderable: false },
            { data: 'city', name: 'city', defaultContent: '-', orderable: false  },
            { data: 'product_id', name: 'product_id', className: 'd-none d-sm-table-cell', defaultContent: '-' },
            { data: 'totalPrice', name: 'totalPrice', className: 'd-none d-sm-table-cell', defaultContent: '-' },
        ],

edit:

Finally, I found solution

{data: 'added_column', name: 'actual_column_name'}

https://github.com/yajra/laravel-datatables/issues/139#issuecomment-275326787

Please post your function in order model where to get getFullname() — BKF
– BKF, Commented Jan 28, 2020 at 7:25

Yasir · Accepted Answer · 2020-06-05 19:38:43Z

1

Finally, I found solution

{data: 'added_column', name: 'actual_column_name'}

https://github.com/yajra/laravel-datatables/issues/139#issuecomment-275326787

answered Jun 5, 2020 at 19:38

Yasir

1,1201 gold badge14 silver badges31 bronze badges

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

1 Comment

Sizzling Code Over a year ago

Nice share, works like a charm. :)

ali hassan · Accepted Answer · 2022-09-26 20:33:11Z

1

change status

serverSide : false

 "pageLength": 10,
        processing: true,
        serverSide: false,
        ajax: 'orders',
        columns: [
            { data: 'id', name: 'id'},
            { data: 'fullname', name: 'fullname', defaultContent: '-' , orderable: false },
            { data: 'city', name: 'city', defaultContent: '-', orderable: false  },
            { data: 'product_id', name: 'product_id', className: 'd-none d-sm-table-cell', defaultContent: '-' },
            { data: 'totalPrice', name: 'totalPrice', className: 'd-none d-sm-table-cell', defaultContent: '-' },
        ],

answered Sep 26, 2022 at 20:33

ali hassan

4596 silver badges5 bronze badges

Comments

BKF · Accepted Answer · 2020-01-28 08:40:01Z

-1

Make sure to have relationship into Order model like this:

public function user()
{
    return $this->belongsTo('App\User');
}

Try to update like this :

...
    ->addColumn('fullname', function (Order $order) {
           return $order->user->fullname;
     })
...

answered Jan 28, 2020 at 8:40

BKF

1,3664 gold badges16 silver badges35 bronze badges

1 Comment

Yasir Over a year ago

I think you didnt understand my question. I dont have any problem with to list data. There is no problem. I just want to search in row which I added with addColumn function.

Collectives™ on Stack Overflow

laravel datatables search in addColumn

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related