Table group of groups?
Is it possible to nest grouping or groups in tables?
I basically have a pivot table that lists a number of items and links them to a listing of people. Each of the items relates to a given location.
So basically I have something like:
Person model
- using person.name
Item model
- using item.name and item.location
Pivot relation model
- has a pivot.person and pivot.item relationship
Basically I would like to group these by locations -> persons - > items
So that:
the outer groups would be the various locations of the items
locations would be grouped into persons the items relate too
each lotation -> person would then list those items related to that person in that location
I basically have a pivot table that lists a number of items and links them to a listing of people. Each of the items relates to a given location.
So basically I have something like:
Person model
- using person.name
Item model
- using item.name and item.location
Pivot relation model
- has a pivot.person and pivot.item relationship
Basically I would like to group these by locations -> persons - > items
So that:
the outer groups would be the various locations of the items
locations would be grouped into persons the items relate too
each lotation -> person would then list those items related to that person in that location
