Level 47
So you want the category names to also be sorted? Maybe just use sort()?
$groups = $collection->groupBy('category.name')->sort();
Apr 25, 2016
5
Level 1
Collection - orderBy / sortBy
Hi,
I have some items that belongs to some categories, the following code gives me the items grouped in their categories, the items are sorted ASC. I want also the categories to be sorted in ASC.
public function itemsList()
{
$collection = Item::with('category')->where('status', 1)->orderBy('name', 'ASC')->get();
$groups = $collection->groupBy('category.name');
return view('pages.items.list', compact('collection', 'groups'));
}
I tried... with no luck...
public function itemsList()
{
$collection = Item::with('category')->where('status', 1)->orderBy('name', 'ASC')->get();
$groups = $collection->groupBy('category.name')->sortedBy(category.name);
return view('pages.items.list', compact('collection', 'groups'));
}
Please any advice will be much appreciated.
Level 1
Hi @zachleigh,
Thank you for your time... your advice sorts the data in a different way, not by the name of the category or its id...
Level 47
What about if you reverse the order of sortBy and groupBy?
$groups = $collection->sortBy(category.name)->groupBy('category.name');
2 likes
Level 1
Hi @zachleigh,
Just to say thank you... your advice worked!
1 like
Level 1
Hi...
I did not noticed that the solution has the categories in ASC but the items are not in ASC any more...
public function itemsList()
{
$collection = Item::with('category')->where('status', 1)->orderBy('name', 'ASC')->get();
$groups = $collection->sortBy('category.name')->groupBy('category.name');
return view('pages.items.list', compact('collection', 'groups'));
}
Please or to participate in this conversation.