Level 75
Is it difficult to open the documentation and read?
https://datatables.yajrabox.com/eloquent/joins
https://yajrabox.com/docs/laravel-datatables/master/engine-eloquent
1 like
Feb 20, 2022
4
Level 3
How to use Yajra DataTables with raw query and not model?
The docs show that you need a Model that corresponds to the DataTable:
public function query(User $model)
{
return $model->newQuery();
}
But what if I have some more complex query that is not a Model? For example:
return $data = Auth::user()->select(//...)
->where(//...)
->where(\DB::raw(//...))
->leftJoin(//...)
->get();
How to make it work with Yajra?
Level 3
@MichalOravec But look the docs always return a model:
No But I was talking about something else. But I found it:
I just use
public function dataTable($query)
{
return datatables()
->collection($query);
}
instead of
public function dataTable($query)
{
return datatables()
->eloquent($query)
}
Level 75
@cooperino From the documentation....
$posts = Post::join('users', 'posts.user_id', '=', 'users.id')
->select(['posts.id', 'posts.title', 'users.name', 'users.email', 'posts.created_at', 'posts.updated_at']);
return Datatables::of($posts)->make(true);
Do you see ->get() there? No!
1 like
Level 3
@MichalOravec Ok that's a good way.
In my case specifically it had joins but sometimes you just get a raw query (not necessarily with joins), then I think the docs mention what I did - to use the collection method (So in my case I can use both, and now I will try your way as well)
Please or to participate in this conversation.