Laravel 6 groupBy to belongsTo relationship

Question

Hello I have Post model with relation:

public function category()
{
    return $this->belongsTo(category::class);
}

I need show posts on every tab of category. For this I need use groupBy. When I do this:

$posts = Post::with('category')->groupBy('category.title')->get();

I get error:

Column not found: 1054 Unknown column 'category.title'.

Why? How I can return my posts with key of category title?

show the rsults of `Post::with('category')->groupBy('category.title')->dd()` probably your table name is `categories` — Shobi, Dec 29 '19 at 16:39

Hafez Divandari · Accepted Answer · 2019-12-29T17:06:40.893

2

$posts = Post::with('category')->get()->groupBy('category.title')->all();

You may pass a callback to return the value you wish to key the group by (as you mentioned you are using laravel-translatable package):

$posts = Post::with('category')->get()->groupBy(function ($post, $key) {
    return $post->category->getTranslation('title', 'fr');
})->all();

edited Dec 29 '19 at 17:06

answered Dec 29 '19 at 16:40

Hafez Divandari

Not work, because I use this: https://github.com/spatie/laravel-translatable in title I have a json. – Mafys Grif Dec 29 '19 at 16:50
@MafysGrif would you please edit your question and add a code to show how you use `laravel-translatable` package? – Hafez Divandari Dec 29 '19 at 16:53

score 0 · Answer 2 · answered Dec 29 '19 at 16:42

0

You can use something like this:

$posts = Post::all()->groupBy('category_id')->get();

and then in blade files you can foreach tabs and find a name by category_id

answered Dec 29 '19 at 16:42

knubbe

2 Answers2