StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMagento Pagination bar Limiting the number of items
primarykey
Id
7350568
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-09-08T15:27:28.247
FavoriteCount
1
LastActivityDate
2011-12-04T17:16:34.710
LastEditDate
2011-09-09T14:57:41.317
LastEditorUserId
172376
OwnerUserId
172376
ParentId
0
PostTypeId
1
Score
2
ViewCount
3339
LastEditorDisplayName
text
Body
In magento ,I need to load only top 20 items from product collections with pagination bar(pagination bar should only have 4 pages because its only have 20 items - But in my case its having total product collection because magento pagination bar is taking whole collection object for creating toolbar without limit property). I have the following code <pre><code> $_productCollection = Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect('*') ->addOrderedQty() ->setPageSize($limit) ->setPage($p, $limit) ->setOrder('ordered_qty', 'desc'); </code></pre> And this returned 20 items correctly. When i set this to pagination bar by following method. <pre><code>$magento_block = Mage::getSingleton('core/layout'); $productsHtml = $magento_block->createBlock('catalog/product_list'); $productsHtml ->setTemplate('catalog/product/list.phtml')->setCollection($_productCollection); $pager = $magento_block->createBlock('page/html_pager', 'catalog/product_list')->setCollection($_productCollection); $productsHtml->setChild('pager', $pager); </code></pre> Its taking all the product collection instead of just 20 items for creating toolbar. So i added a where condition in the productcollection itself as follows. <pre><code>$_productCollection->getSelect()->where("order_items.qty_ordered >= 50"); </code></pre> This collection returns items which are sold more than 50 quantities. But what i want is exactly 20 items with correct pagination bar. How can i setLimit in pagination bar. The following also does not worked for me <pre><code>$magento_block->createBlock('page/html_pager', 'catalog/product_list')->setCollection($_productCollection)->setLimit(20); </code></pre> Note: Am loading this product collection outside Magento Enterprise 1.9 version and not with in magento template. Can someone find whats the mistake am doing here?
Tags
<magento>
Title
Magento Pagination bar Limiting the number of items
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USElamurugan
UserOwnerUserId
1. USElamurugan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POMagento Pagination bar Limiting the number of items
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POMagento Pagination bar Limiting the number of items
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 POMagento Pagination bar Limiting the number of items
 UserUserId
 USmatrixcruiser
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.