Return to Question

make highlighted

Source Link

edit approved Apr 26, 2018 at 14:27

2.1k
3
25
48

I am trying to add where in collection but it return Varien_Db_Select Object instead

Varien_Db_Select Object

instead of return collection object.

$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');

and iI want specific column value in array instead of looping through each object.

I am trying to add where in collection but it return Varien_Db_Select Object instead of collection object.

$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');

and i want specific column value in array instead of looping through each object.

I am trying to add where in collection but it return

Varien_Db_Select Object

instead of return collection object.

$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');

and I want specific column value in array instead of looping through each object.

Source Link

asked Apr 26, 2018 at 14:24

Pradip Garchar

How to get collection object when use where in collection

I am trying to add where in collection but it return Varien_Db_Select Object instead of collection object.

$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');

and i want specific column value in array instead of looping through each object.

magento-1.9 collection