Querying data - top 5 products

[bilginkilic]

$items = Product::uses(['text', 'media', 'price','name'])
->category(1)
->sort('name')->slice(0, 48)->search();

how to put site_id condition an extra filter like product limitation, etc in this query?

major point is.. how to fetch limited product..

Like i want to list only 5 items.

ps: current query is picking product price is in euro and usd both..

We wanted to pick only based on store configuration.

[aimeos]

To add a site ID filter and limit the items to 5, use:

Code: Select all

$items = Product::uses(['text', 'media', 'price','name'])
    ->compare('==', 'product.siteid', '<site ID string>')
    ->category(1)->sort('name')->slice(0, 5)->search();