A puzzle for y'all:
I'm trying to generate a list that returns only unique values, like an SQL Select Distinct query.
Essentially, I have a list of stores, and want to show a list of the products carried at each store. I populate this list based on line items on connected invoices. This works well, except if a store has ordered the product multiple times, it will show up on the product listing once for each time it was ordered.
Any solutions / workarounds?
Thanks for reading!