Magento 2 Update record/table with where clause

Question

How can I update record with multiple where clause? I know below method to update record with single where condition. I tried to used addFieldToFilter() but not succeeded.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$order_ = $objectManager->create('<ext_name>\<module_name>\Model\OrderSaleslist')
                                       ->load($orderId); 
$order_->setSellerOrderConfirm("dispatched");
$order_->save();

I want to apply below query.

Update ordersaleslist set seller_order_confirm = 'dispatched', payment_mode = 'COD' where order_id = 1 and product_id = 20 and (status !='' OR dispatched_status!='');

Thanks in Advance.

score 8 · Accepted Answer · edited Apr 13 '17 at 12:55

you can apply multiple where with AND logic

e.g

    $collections = $this->_yourFactory->create()->getCollection()
                 ->addFieldToFilter('order_id', array('eq' => '1'))
                 ->addFieldToFilter('product_id', array('eq' => '20'));
    foreach($collections as $item)
    {
        $item->setSellerOrderConfirm('dispatched');
        $item->setPaymentMode('COD');
    }
    $collection->save();

object manager is not recommended. load and save methods are deprecated for best practice you should use service contracts. for more info refer this link

score 1 · Answer 2 · answered Mar 22 '19 at 09:37

 <?php
namespace Vendor\MyModule\Model;

use Magento\Framework\Model\AbstractModel;
 class Products extends AbstractModel
    {
        protected function _construct()
        {

            $this->_init(\Vendor\MyModule\Model\ResourceModel\Products::class);
        }
        public function setProduct($newProductId){    
           $collection = $this->getCollection()->addFieldToFilter('product_id', $);
           $collection->getFirstItem()->setData('product_id',$newProductId)->save();
        }
}

I update product Id using collection in magento2 I called setProduct() from the controller.

main logic to update is

 $collection = $this->getCollection()->addFieldToFilter('product_id', $);
               $collection->getFirstItem()->setData('product_id',$newProductId)->save();

Chirag Prajapati · Answer 3 · 2016-11-17T06:18:23.527

0

You have used two time

$order_->setSellerOrderConfirm("dispatched")->setSellerOrderConfirm("dispatched")

just use once $order_->setSellerOrderConfirm("dispatched").

if not work then you can use like this,

$order_->addFieldToFilter('order_id ', array('eq' => 1));

May be it will help you.

edited Nov 17 '16 at 06:18

answered Nov 17 '16 at 06:08

Chirag Prajapati

2,922
2
18
42

Thanks, I am not looking for this, Please check query. I want multiple where condition for update record – Dev Nov 17 '16 at 06:14
you can use addFieldToFilter as many time as you want. – Chirag Prajapati Nov 17 '16 at 06:17

Magento 2 Update record/table with where clause

3 Answers3