i created my own table (orer_to_prepare) to add information regarding an order.
In this way, i created model class “class MDN_MageCustomization_Model_OrderToPrepare extends Mage_Core_Model_Abstract”
I successfully retrieve records with getcollection method.
I also succeed to add filter.
However, i’d like to retrieve information from both sales_order and OrderToPrepare tables.
OrderToPrepare contains a foreign key named order_id that refers to entity_id field.
So i try to get all fields from sales_order and OrderToPrepare using that relation.
I wrote that:
$this->_SelectedOrders = Mage::getResourceModel('sales/order_collection')
->addFieldToFilter('entity_id', array('in'=>$list_selected)) ->joinField('shipment_created',
However, it doesn’t work, i get the following error msg:
incorrect attribute name: order_id
Any idea ?
Thanks in advance !