How do i join two queries and then paginate

Question

    $data = Category::join('articles', function ($join) {
       $join->on('categories.id', 'articles.category_id')
        ->where('categories.type', 'news')
        ->where('articles.status', '1');
    })->get()->sortByDesc('updated_at')->paginate(5);

I have 2 variables both querying the same model. I want to now merge these 2 separate datasets into a variable called $articles and then paginate on it.

Just remove get() and your query should work. – Web Artisan Nov 08 '18 at 14:41 — Web Artisan, Nov 08 '18 at 14:41

score 0 · Accepted Answer · answered Nov 08 '18 at 15:09

Remove the get() method from the code like:

$data = Category::join('articles', function ($join) {
    $join->on('categories.id', 'articles.category_id')
    ->where('categories.type', 'news')
    ->where('articles.status', '1');
})->sortByDesc('updated_at')->paginate(5);

It should work.

score 0 · Answer 2 · answered Nov 09 '18 at 00:37

0

When joining queries and paginate in controller, to view the output in paginate you should include this under you for loop output:

{{ $data->links() }}

answered Nov 09 '18 at 00:37

joun

656
1
8
25

How do i join two queries and then paginate

2 Answers2