Can't get pull operations quite right

[nicolasvahidzein]

I can't get my pull operation quite right, can someone help me please?

I am trying to remove an element in a nested array inside mongo in my laravel project. I tried many ways to do it but after checking nothing was changed in my array.

I tried multiple way with no luck

 $removeItem = Carts::query() ->where('userUID', '=', $user->UID) ->where('cart', '=', 'default') ->where('items.item', '=', $item['item']) ->pull( 'items', 'items.$', ); 

i tried this as well:

 $removeItem = Carts::query() ->where('userUID', '=', $user->UID) ->where('cart', '=', 'default') ->where('items.item', '=', $item['item']) ->pull( 'items', [ 'item' => 'items.$.item', 'location' => 'items.$.location', 'price' => 'items.$.price', 'quantity' => 'items.$.quantity', 'status' => 'items.$.status', 'added_on' => 'items.$.added_on', 'updated_on' => 'items.$.updated_on', 'deleted_on' => 'items.$.deleted_on', ] ); 

My document structure can be seeing here:

I also posted on SO just in case:
https://stackoverflow.com/questions/63085367/pull-an-item-from-a-mongodb-array-using-jessengers-laravel

[mean-cj]

i confirm the same problem pull method not work for me.

• jenssegers/laravel-mongodb v.dev
• Mongo version 4.2.5

My data

 #attributes: array:23 [ "_id" => MongoDB\BSON\ObjectId {#587 +"oid": "5f19e43f5180dd220976066f" } "total_info" => array:2 [ 0 => array:3 [ "description" => "ส่วนลด 50 บ. ซื้อขั้นต่ำ 99 บ." "value" => -50 "campaign_id" => "5f1083f9ac29ac79c7529af4" ] 1 => array:3 [ "description" => "ส่วนลด 50 บ. ซื้อขั้นต่ำ 99 บ." "value" => -50 "campaign_id" => "5f1083f9ac29ac79c7529af4" ] ] 

$order->pull('total_info', [ 'campaign_id' => '5f1083f9ac29ac79c7529af4' ]); 

Query Log
db.merchant_order.UpdateMany({"$and":[{"_id":"5f19e43f5180dd220976066f"},{"deleted_at":null}]},{"$pull":{"total_info":{"campaign_id":"5f1083f9ac29ac79c7529af4"}}},{"multiple":true})

Thanks

[nicolasvahidzein]

I was able to fix it by adding the variable name to it and also because i am removing an index, going in reverse like so:

 for ($i=count($userCartBis['items']) - 1; $i >= 0; $i--) {	//for now remove each element from the cart and put it in the orders section, if it's active	if ($userCartBis['items'][$i]['status'] == 'active') {	//this one we can process	//add it to the orders table	$updateOrder = $order	->push(	'products',	[	'location'	=> $userCartBis['items'][$i]['location'],	'quantity'	=> $userCartBis['items'][$i]['quantity'],	'price'	=> $userCartBis['items'][$i]['price'],	'product'	=> $userCartBis['items'][$i]['item'],	]	);	//remove it from the cart table	$removeItem = $userCart	->pull(	'items',	$userCartBis['items'][$i],	);	} else if ($userCartBis['items'][$i]['status'] == 'deleted') {	//it is already deleted	//do nothing for now	}	}