Magento Set LIMIT on collection

Question

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

User · Answer

The way to do was looking at the code in code/core/Mage/Catalog/Model/Resource/Category/Flat/Collection.php at line 380 in Magento 1.7.2 on the function setPage($pageNum, $pageSize)

 $collection = Mage::getModel('model')
     ->getCollection()
     ->setCurPage(2) // 2nd page
     ->setPageSize(10); // 10 elements per pages

I hope this will help someone.

User · Answer

Order Collection Limit       orderCollection   Mage  getResourceModel  sales order collection      orderCollection- gt getSelect  - gt limit 10    foreach   orderCollection- gt getItems   as  order        orderModel   Mage  getModel  sales order        order      orderModel- gt load  order  entity id        echo  order- gt getId     lt br gt     endforeach

User · Answer

You can Implement this also - setPage 1  n    where  n   any number    products   Mage  getResourceModel  catalog product collection                   - gt addAttributeToSelect                      - gt addAttributeToSelect array  name    price    small image                    - gt addFieldToFilter  visibility   Mage Catalog Model Product Visibility  VISIBILITY BOTH    visible only catalog  amp  searchable product                 - gt addAttributeToFilter  status   1     enabled                 - gt setStoreId  storeId                  - gt setOrder  created at    desc                   - gt setPage 1  6

User · Answer

There are several ways to do this    collection   Mage  getModel                    - gt getCollection               - gt setPageSize 20              - gt setCurPage 1     Will get first 20 records   Here is the alternative and maybe more readable way    collection   Mage  getModel       - gt getCollection     collection- gt getSelect  - gt limit 20     This will call Zend Db limit  You can set offset as second parameter

[magento] Magento: Set LIMIT on collection

Examples related to magento

Examples related to collections