Daisy wrote:
> The main issue is: Our page needs 80 products to display from different
> suppliers per keyword search. We have some of the search keywords
> which only have less than 80 suppliers.
Okay. The number of products per supplier gets averaged? So if 1
The main issue is: Our page needs 80 products to display from different
suppliers per keyword search. We have some of the search keywords which only
have less than 80 suppliers. If we use groupby(supplier), the 80 products per
page is not possible anymore.
Regards,
Daisy
-Original
On Thu, 2016-12-22 at 17:35 +0800, Daisy wrote:
> How to restrict the product search in a marketplace where no more
> than 3 results per retailer are permitted in search results?
>
> I understand the groupby/collapse could solve the issue but is there
> any other way to do it?
Grouping is the