0

There are a couple of questions relating to adding a custom email field to the order grid. For example, this and this.

However, both these create a problem when you try and filter. What happens is that whilst you can search the new email field, if you search via order ID, store, or Purchased On - then you are taken to the Dashboard, and when you return to the Order grid, you get an error.

For the sake of example, I am using the following code to make the join in _prepareCollection

$collection->getSelect()->joinLeft( array('myorder'=>'sales_flat_order'), 'myorder.entity_id = main_table.entity_id', array('myorder.customer_email') );

and the following to call it in _prepareColumns:

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

Anyone any ideas what is wrong with this code?

Improve this question

1 Answer 1

Reset to default
1

I tried the code and the error was: "Integrity constraint violation: 1052 Column 'increment_id' in where clause is ambiguous". It's happening because there is duplicate column. So you should modify the where clause or simply to change the table. Try with the address table, it's working fine:

$collection->getSelect()->joinLeft( array('oa' => 'sales_flat_order_address'), 'oa.entity_id = main_table.entity_id', array('oa.email') )->where("oa.address_type = 'billing'");

and

$this->addColumn('email', array( 'header' => $this->helper('sales')->__('Customer Email'), 'index' => 'email', 'filter_index' => 'oa.email', ));
Improve this answer
1
  • Thanks for this. I noticed that the emails it was displaying were actually wrong (which may be something to do with my running two stores), but it put me on the right path to finding this - magento.stackexchange.com/questions/12273/… - which solved it. Commented Feb 26, 2015 at 22:58

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.