Apologies if this question has an overly obvious answer. I am just getting my head around SilverStripe. Loving it so far.
Using the E-Commerce module, I am dealing with the ProductGroups class. Each ProductGroup pulls a number of products.
The Products objects have a "has_one" relationship with a DataObject "Brand" which I created.
On each ProductGroup, I am wanting to pull a unique list of brands available within it's selection of products.
Aside from doing an Sqlquery with hand written mysql, can anyone offer some insight into how I might pull this distinct list of brands at the ProductGroup level?