Magento News

 

using group() breaks getSelectCountSql in magento

Hi

When I’m using $collection->getSelect()->group(‘entity_id’)
or $collection->groupByAttribute(‘entity_id’)
it breaks getSelectCountSql and I’m getting 1 record and 1 page.
Magento does $countSelect->columns(‘COUNT(DISTINCT e.entity_id)’);

Is there a way to fix it?

I run into it when overriding _prepareCollection of Mage_Adminhtml_Block_Catalog_Product_Grid

Thanks

using group() breaks getSelectCountSql in magento

Possibly Related Posts:


 

Leave a Reply