1

Do we have any choice of calling a callback function for sorting? Just like

filter_condition_callback

As

 'sort_callback' => array($this, 'sortingfun'),

2 Answers 2

1

I faced the same problem today. I solved it by adding joins to the _prepareCollection which I added to the filter_condition_callback. Then added the table.column name for the 'index' in $this->addColumn. (In my case: catalog_product_entity.sku).

In the _prepareCollection I added:

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());

    // add to make skus sortable
    $collection->getSelect()->join(
                'sales_flat_order_item',
                'main_table.entity_id=sales_flat_order_item.order_id',
                array('product_id')
                )
            ->join(
                'catalog_product_entity',
                'sales_flat_order_item.product_id=catalog_product_entity.entity_id',
                array('sku')
            );

    $this->setCollection($collection);
    return parent::_prepareCollection();
}

This link helped me too: Column isn't Sorting in Custom Admin Report

0

for fix sort - need override method _setCollectionOrder,

for example my solution

protected function _setCollectionOrder($column)
{
    if (!$dir = $column->getDir()) {
        return $this;
    }

    if ($column->getIndex() == 'orders_count') {
        $collection = $this->getCollection();
        $collection->getSelect()
            ->order("orders_count " . strtoupper($column->getDir()));
        return $this;
    }

    if ($column->getIndex() == 'orders_total') {
        $collection = $this->getCollection();
        $collection->getSelect()
            ->order("orders_total " . strtoupper($column->getDir()));
        return $this;
    }

    return parent::_setCollectionOrder($column);
}

Your Answer

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

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