Hello All,
I’m trying to determine an elegant way to do a nested group_by. What
I would like to do is group records pulled from the database by one
field and then another and display them in the view. Ideally it would
look something like this:
Controller:
@groups = Record.all.group_by(&:field1).group_by(&:field2)
In the View:
<% @groups.each do | field1, group1 | %>
<% field1 %>
<% field2.each do | field2, group2 |
<% field2 %>
<% group2.each do |record| %>
<% record.name %>
<% end %>
<% end %>
I’ve been able to do the second group_by in the view code, flatten it
into and array and then loop through it, but that seems hackish. What
I’m shooting for is to allow the user to pick two fields to group by
in a form submit and then print out a report with the data grouped in
that way.
Any thoughts?
Thanks,
Nick