Using with and withCount together in laravel eloquent

Question

withCount is a new method of laravel to return count of the relations. I'm trying to use with and withCount together. For example:

Article::with('Comments')->withCount('Comments')->paginate();

Problem I'm facing is, in the results is see for example:

comments_count = 10
comments = []

It returns comments array null. I don't know is it possible to get both the results or not. In some articles on different sites, i see withCount still has some restrictions. But not sure what I'm trying to do is possible or not.

Please help me to know about this issue.

Thank you,

yes. it is possible to get both results. and your code is fine to do that. can you show the result of that query? — Sanzeeb Aryal
– Sanzeeb Aryal, Commented Jan 31, 2017 at 13:10
if I use only "WITH" it returns: comments:[{id:1, comments:"---"},{id:2, comments:"-----"}], if I use online withCount, it returns: comments_count:2.... and if I use both it returns: comments:[], comments_count:2 — Nadim Aseq A Arman
– Nadim Aseq A Arman, Commented Jan 31, 2017 at 13:37

Pooja JaJal · Accepted Answer · 2017-01-31 12:53:18Z

1

No Need to write with.

Article::withCount('Comments')->paginate();

answered Jan 31, 2017 at 12:53

Pooja JaJal

3031 silver badge4 bronze badges

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

2 Comments

Nadim Aseq A Arman Over a year ago

Thanks for the reply. But unfortunately this didn't worked for me. I tried this but it returns only "comments_count" without comments. I need comments array too.

Alexey Mezenin Over a year ago

This will not load the relationship, OP's code is correct.

Collectives™ on Stack Overflow

Using with and withCount together in laravel eloquent

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related