Magento 2 – How to Get Collection of Sales Order Status History Models by Parent ID

collection;magento2

Magento 2 has order status history inside each order which essentially is just comments related to a order. All of them are stored in one single database table sales_order_status_history. Each comment relates to order by value in column parent_id which maps to order_id. I have a set of order id's in an array.
My end goal is to get an array or a collection with comments related to those orders with single query to make it more efficient. I don't want to write direct database queries. I want to utilize collections functionality that I believe allows you to do something like that.

Best Answer

Assuming $ids is an array, the collection would need to be filtered like this:

$collection->addFieldToFilter('parent_id', array('in' => $ids));

This will allow you to filter by an array.

Related Solutions

Magento – Most efficient way to get all ID’s from a collection

Actually getAllIds is the best way of doing it. For example in the product collection resource model the method looks like this:

public function getAllIds($limit = null, $offset = null)
{
    $idsSelect = $this->_getClearSelect();
    $idsSelect->columns('e.' . $this->getEntity()->getIdFieldName());
    $idsSelect->limit($limit, $offset);
    $idsSelect->resetJoinLeft();

    return $this->getConnection()->fetchCol($idsSelect, $this->_bindParams);
}

So everything is retrieved from a single select and no iteration is required. Also in the abstract resource model it looks like this:

public function getAllIds()
{
    $idsSelect = clone $this->getSelect();
    $idsSelect->reset(Zend_Db_Select::ORDER);
    $idsSelect->reset(Zend_Db_Select::LIMIT_COUNT);
    $idsSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
    $idsSelect->reset(Zend_Db_Select::COLUMNS);

    $idsSelect->columns($this->getResource()->getIdFieldName(), 'main_table');
    return $this->getConnection()->fetchCol($idsSelect);
}

So everything that extends Mage_Core_Model_Resource_Db_Collection_Abstract should use this unless specified otherwise.

The method you looked at comes from the base class Varien_Data_Collection but it is overwritten in its children.

Magento – How set order with custom field column magento 2

Whenever you try to use setOrder for a custom column it will take no effect.

$subject->getCollection()->setOrder('price_sort', ' DESC');

You instead need to access the select directly

$subject->getCollection()->getSelect()->order('price_sort DESC');

It should be noted that a side effect of adding order queries this way will be placed before all order queries placed using the setOrder method.

Best Answer

Related Solutions

Magento – Most efficient way to get all ID’s from a collection

Magento – How set order with custom field column magento 2

Related Topic