How to order a database collection?

dmitrii_fediuk (Dmitrii Fediuk) April 4, 2016, 3:29pm 1

A base database collection class (\Magento\Framework\Data\Collection\AbstractDb) has a public getSelect() method which returns a \Magento\Framework\DB\Select instance:

github.com

magento/magento2/blob/ab051bf/lib/internal/Magento/Framework/Data/Collection/AbstractDb.php#L189-L197


/**
 * Get \Magento\Framework\DB\Select instance
 *
 * @return Select
 */
public function getSelect()
{
    return $this->_select;
}

So you can just foillow the instruction How to order a database result-set?

An example:

github.com

magento/magento2/blob/ab051bf/app/code/Magento/Catalog/Model/ResourceModel/Product/Collection.php#L1631-L1631


$this->getSelect()->order("is_saleable " . $dir);

How to order categories by an attribute?