SQL Like LIMIT function, only return a given number of results

[genevieve charbon]

Hi,

I'd like to have a relationship taht only returns the 3 most popular products of each categories of my inventory in a portal.

So my portal would show

Cat 1 Product23

Cat 1 Product45

Cat 1 Product65

Cat 2 Product10

Cat 2 Product01

Cat 2 Product56

Of course each categories contains a lot of products.

I've no problem to display my products broke down by categories in my portal, but I've trouble to limit their numbers.

So I need a relationship that would only list the top 3 items of the categories.

So I need to be able to set key field on only the 3 mots popular products of thir categories. And of course that needs to be indexable.

How to do it ?

[comment]

A calculation based on sibling records cannot be indexable, so basically you have two options, I think: either do a scripted fast summary, picking the IDs of the top three products at each category, or try the attached.

TopNinCategory.fp7.zip

[genevieve charbon]

Thanks,

This helped a lot