When having withCount & where at the same time - the results are not paginated, search and ordering don't work

[FilipQL]

Summary of problem or feature request

When having withCount & where at the same time - the results are not paginated, search and ordering don't work.

Code snippet of problem

When I use withCount & where at the same time - the results are not paginated (DataTable shows Showing 0 to 0 of 0 entries), search and ordering don't work:

        $articles = Article::select('articles.*')
            ->withCount('comments')
            ->with(['market', 'category', 'user'])
            ->where('articles.market_id', 1);

When I remove where and leave withCount:

        $articles = Article::select('articles.*')
            ->withCount('comments')
            ->with(['market', 'category', 'user']);

... everything works OK. Also, when I remove withCount and leave where:

        $articles = Article::select('articles.*')
            ->with(['market', 'category', 'user'])
            ->where('articles.market_id', 1);

... everything works OK. Do you know why is this happening and how can I fix this?

If it can help, here are queries for the case where withCount and where are used at the same time:

System details

• Operating System: Ubuntu 16.04 (Laravel Homestead)
• PHP Version: PHP 7.1 (Laravel Homestead)
• Laravel Version: 5.4.36
• Laravel-Datatables Version 8.3.1

[swash13]

same issue, if i write this in my model it's working OK:
return $this->hasMany(JobAnalytic::class);

But if i will add where condition - no paginate and sorting and search:
return $this->hasMany(JobAnalytic::class)->where('job_analytics.action_type', JobAnalytic::APPLY_NOW_BTN_CLICKED);

[ikerasLT]

Same issue here.

Just to point to the right direction:

Row count query seems to omit with_count queries but not associated bindings:

[yajra]

Can you please check again using v8.5.1, this be fixed by #1737 and #1730. Thanks!

[github-actions]

This issue is stale because it has been open for 30 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been inactive for 7 days since being marked as stale.