add customer email in sales order grid magento

Question

how can i add customer email in admin html grid magento. i get customer email in collection but not displayed in column of Customer Email. Please Help me.

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->join('order', 'main_table.entity_id = order.entity_id', 'customer_email');
    $this->setCollection($collection);
    return parent::_prepareCollection();
}
protected function _prepareColumns()
{
        $this->addColumn('customer_email', array(
        'header' => $this->helper('sales')->__('Customer Email'),
        'index' => 'customer_email',
    ));
}

Answer 1

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->joinLeft(
        array('myorder'=>'sales_flat_order'),
        'myorder.entity_id = main_table.entity_id',
        array('myorder.customer_email')
    );
    $this->setCollection($collection);

    return parent::_prepareCollection();
}

You need to add filter_index to code

$this->addColumn('customer_email', array(
    'header' => $this->helper('sales')->__('Customer Email'),
    'index' => 'customer_email',
    'filter_index' => 'myorder.customer_email',
));

Answer 2

In Grid.php:

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()
        ->join(
            'customer_entity',
            'main_table.customer_id = customer_entity.entity_id', array('customer_name' => 'email')
        );
    $this->setCollection($collection);

    return parent::_prepareCollection();
}

Then in protected function _prepareColumns() function add following code:

$this->addColumn('thumbnail', array(
    'header'    => Mage::helper('Sales')->__('Email'),
    'width'     => '100px',
    'index'     => 'customer_name',
    'type'        => 'text',
));

I think this link will solve your problem if you want to do more.

I know it was better to share the code, but the code is too much that's why I preferred to share the Link.