ok, there isn't a groupby - option with the default processor, yet
you will need to create a custom getlist-processor with
$c->groupby('productLine.id');
to remove duplicates.
But didn't you say, every product-line has only one productLineColorGroup, how come the duplicates?
-
☆ A M B ☆
- 222 Posts
Most likely legacy data from the original need to have a many-to-many relationship. I am cleansing the data today on this.
Removing the JoinAlias did fix the number of rows issue on this, and with the new requirement of not needing to relate ProductLines to ProductColorGroups, most of this is resolving itself.
