tags:

views:

29

answers:

0
Q: 

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

related questions

is magento overkill for a one-man webshop?
Removing an Item from Magento's Admin Panel Navigation
magento login module
what is the best way to learn magento?
B2B open source solutions
Using Magento's addFieldToFilter to filter by existing columns
Magento Themeing
c# translation to PHP Array key
Export Orders from Magento for shipment
How to get a category listing from Magento?
How does Magento code work?
Where is the setCouponCode function is defined in Magento
PHP 5 and Zend MVC on Windows and IIS
Generic SOAP Debugging Tools
Best beginner resources for understanding the EAV database model?
How to make "Tag" pages SEO'd in Magento?
Create SQL query that orders results by which condition they meet
Custom eCommerce Site - ASP.Net or PHP?
How to get products from a particular category in magento ecommerce
Current user in Magento?
Magentocommerce - How to exclude 'out of stock' items from the front page?
Hide categories that have no products magento
Maintain runtime settings across environments in version control?
Magento products by categories
Help with Magento Custom Module. Redirect to another module and return to checkout