How to group a list of things by another thing

[johndurso]

I have a RG that Searches for and lists a thing called Product Groups. Each Product Group has a thing called Product Type, and I want the list of Product Groups to display grouped by Product Type. For example:

Product Group A - Type 1
Product Group B - Type 1
Product Group C - Type 2
Product Group D - Type 2
Product Group E - Type 2
Product Group F - Type 3
etc.

The “group by” is for aggregating data, doesn’t seem to work for this. The “sort by” doesn’t allow me to select the Product Type field. Seems like this should be simple, but I can’t find a method to sort/group in this way.

Any ideas how I might accomplish this?

Thanks!

[J805]

Hey @johndurso

I know the sort by feature only works with text or number fields I think. Maybe group by is set up the same way?

Maybe try adding another field that is a text field so it will at least allow you to sort by that field. Let me know if that helps.

[Eugene_West]

Product Type is a “text” or related to a db of types?

[johndurso]

Product Type is a Thing in the database. It has it’s own fields like Name, etc.

[Eugene_West]

You can sort only by number or text type.
Remove “Product Type” from Product Group and add “Product Type” with the type “text”
It will let you group your " product group" by type.
Better use DB Product Type as “options”