Hi there,
I’ve been stuck on something for a while, I give up, please help me if you know some way to do something like this :
Let’s say I have three Things set up :
Some Products, (soya sauce, carrots, french fries…)
Some Brands (Wallmart, Heinz…)
And some Pairs (ketchup-heinz…) pairing one product with a brand, with a price.
Each brand have a lot of product, and some product belong to multiple brands (not only one brand makes coffee for example)
I have a list of product, and I need to find the list of brands someone has to go and find so he can gather all his products (if he wants some ketchup, some cocoa and some shoes, it should show “Nestle, Heinz, Adidas”) with the constraint that it should show the cheapest brand for that given product…
I’m stuck as I don’t know how to get a list of result for Do a search for for each item in my list of product. My first approach is to use a repeating group containing the products, and in each cell have a group with the data-source set to “Do a search for Pair, constraint : product = Current cell’s product; sort by price : first item’s Brand”
But I can’t use the list of Brands that is generated as every element is in a different cell of the repeating group…
(If it helps, as Pairs contains only one brand, retreiving a list of pair instead of a list of brands doesn’t matter)
Hope it is somehow understable, and thanks for reading
Have a good day (or night)