Sales Order – Filter Orders by Customer Email ID

customer-attributesales-order

How I can filter Magento order by any customer email id?
I'm doing something like but I'm not getting the result.

$customer_email ='abc@gmail.com';
$orders = Mage::getModel('sales/order')->getCollection()
    ->addFieldToFilter('customer_email', $customer_email);

Best Answer

Use addAttributeToFilter instead of addFieldToFilter as in some case Sales model follow eav patten filter and select.

$customer_email ='abc@gmail.com';
$orders = Mage::getModel('sales/order')->getCollection()
    ->addAttributeToFilter('customer_email', $customer_email);
Related Topic