I have a custom collection to which I add filters. For example, I have this:

$giftColletion = $this->_giftFactory->getCollection();
$giftColletion->addFieldToFilter('store_id', 1);

What filter should I add to $giftColletion so it can return all the records by field position in ASC order ?

3 Answers 3


You can try this

$giftColletion = $this->_giftFactory->getCollection();
$giftColletion->addFieldToFilter('store_id', 1);

setOrder is use for sorting


According to \Magento\Catalog\Model\ResourceModel\Product\Collection you can use addAttributeToSort() method to sort your collection.

This has worked for me:

$collection = $this->_collection
    ->addAttributeToSelect(['sku', 'name', 'image'])
return $collection;

Use whatever attribute you need your collection to be sorted by instead of 'name' in my example. You can also specify order direction as the second parameter, it defaults to ASC.


Try this,

$page = ($this->getRequest()->getParam('p')) ? $this->getRequest()->getParam('p') : 1;
$pageSize = 10;
$allMagazines = $this->MagazineFactory->create()->getCollection();
$allMagazines->addFieldToFilter('is_enable', 1);
return $allMagazines;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.