HTML/JavaScript

Tuesday, April 8, 2014

Magento – Group by collection in magento


You can try this:

$collection->getSelect()->distinct(true);
But this will retrieve distinct values based on id. If you want to retrieve videos using distinct video values, you should group by “value”.

$collection->getSelect()->group(‘value’);
If you want to debug the query executed :

$collection->getSelect()->__toString();

Hope this helps :)

No comments:

Post a Comment