Laravel-datatables: Many-to-Many relationship is not searchable.

[tepafril]

Basically, I would like to say thank you for your effort to write this package which is really useful.

I have 3 tables which are many-to-many relationship.
-users
-user_role
-roles

I have tried addColumn('roles',function(){});. It totally worked, but unfortunately it's not searchable on the roles column.

Did I miss something? Or there is another to do so? Please instruct me.

[yajra]

@tepafril, can you try this PR and use eager loading demo for ref?

On the other hand, you can also use the join demo for more stable solution.

Thanks!

[tepafril]

The demo of eager loading is not many-to-many relationship. I think it's one-to-many relationship.
I have tried:
$users = User::with('roles')->select('users.*');
return Datatables::of($users)
->make(true);
But still i couldn't search 'roles' column. And yes, it's displaying on the screen.

[yajra]

Yes, the demo is one-to-many but the concept is the same and you need to use PR #490. Forgot to add the link to the PR above.

[tepafril]

Work like a charm! Thank you so much 👍

[yajra]

@tepafril, what approach did you use? Join statements or using the PR? Will merge the PR if that fixes your issue. Thanks!

[tepafril]

@yajra here is my code snippet:

//controller
public function ApiGetAll(){
$transactions = Transaction::with(array('stocks','user'));
return Datatables::of($transactions)->make(true);
}
?>

// hide the column and enable searching
// doing so to enable searching
columns: [
{ data: 'stocks.en_name', name: 'stocks.en_name',searchable:true },
]

[yajra]

I just merged and released PR #490 on v6.11.0. Thanks!