Filter Group By or DISTINCT column

[IvanIgniter]

I am using laravel 6.x, PHP 7.4, Docker desktop/Ubuntu and the Aimeos 2021 (aimeos-laravel: 2021.10.4 / aimeos-core: 2021.10.13)

I have a question about model manager filtering in https://aimeos.org/docs/2021.x/models/search-filter/
I would like to know how can I make a filter like a group by or DISTINCT column name customerid in mshop_order_base table?

Please help..

[aimeos]

The order and order base manager implements the aggregate() method which you can use to group by keys, e.g.

Code: Select all

$manager = \Aimeos\MShop::create( $this->context(), 'order/base' );
$filter = $manager->filter();
$result = $manager->aggregate( $filter, 'order.base.customerid' );

The result will be an associative list of customer IDs and the number of orders per customer.

[IvanIgniter]

Thank you that was working but not as I wanted because it only return an array of customerid and qty it exist.
I would like to get the rows of orderbase those customerid have existed?
Is there a way to filter orderbase table based from the returned aggregated values?

[aimeos]

You have to use the found customer IDs to retrieve their orders afterwards using the search() method of the order/base manager.

[IvanIgniter]

Yap I found a way. Thank you.