Magento: Set LIMIT on collection

magento collections
Shadowbob picture Shadowbob · Jan 14, 2013 · Viewed 123.5k times · Source

The question that I tried to find out was how do we set a Limit on a Collection, the answers that I found on Google was only available for the Catalog with a setPage($pageNum, $pageSize). That didn't work on any other collections.
See the answer below.

Answer

freento picture freento · Jan 14, 2013

There are several ways to do this:

$collection = Mage::getModel('...')
            ->getCollection()
            ->setPageSize(20)
            ->setCurPage(1);

Will get first 20 records.

Here is the alternative and maybe more readable way:

$collection = Mage::getModel('...')->getCollection();
$collection->getSelect()->limit(20);

This will call Zend Db limit. You can set offset as second parameter.

Related questions

Magento get all products

I am trying to get the entire magento product collection, without any filters or restrictions, but I fail to get all products. I've tried various methods already, but they all give me a very limited selection of products. Let's say …

Read More
addAttributeToFilter and OR condition in Magento's Collection

I'd like to select products depending on several criteria from different attribute. I know how to user $collection->addAttributeToFilter('someattribute', array('like' => '%')); But I'd like to use several attribute for OR condition. Like: $collection->addAttributeToFilter(…

Read More
Magento: Filter products by Status

I'm having some serious Magento issues here. As expected the following: $products = Mage::getModel('catalog/category')->load($category_id) ->getProductCollection() ->addAttributeToSelect('*') ->addAttributeToFilter('status', array('eq' => 1)); Will return all enabled …

Read More