blocks|key|1863465|text|不幸的是，在嵌入式数组上不可能执行"upsert“操作。运算符根本不存在，因此这在单个statement.Hence中是不可能的，您必须执行两个更新操作才能执行您想要的操作。另外，这两个更新的应用顺序对于获得所需的结果也很重要。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1863466|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Unfortunately "upsert" operation is not possible on embedded array. Operators simply do not exist so that this is not possible in a single statement.Hence you must perform two update operations in order to do what you want. Also the order of application for these two updates is important to get desired result.

blocks|key|1863475|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1863476|db.collection.update(
++++{+_id+:+ObjectId("57315ba4846dd82425ca2408")},
++++{+$pull:+{"myarray.userId":+ObjectId("570ca5e48dbe673802c2d035")}}
)
db.collection.update(
++++{+_id+:+ObjectId("57315ba4846dd82425ca2408")},
++++{+$push:+{"myarray":+{
++++++++userId:ObjectId("570ca5e48dbe673802c2d035"),
++++++++point:+10
++++}}
)|code-block|syntax|javascript|1863477|解释:在第一个状态中，$pull从文档(+_id+=++ObjectId("57315ba4846dd82425ca2408")+)上的数组中移除带有userId=+ObjectId("570ca5e48dbe673802c2d035")的元素|offset|length|style|CODE|1863478|在第二个数组中，$push将此对象{+userId:ObjectId("570ca5e48dbe673802c2d035"),+point:+10+}插入到同一个数组中。|1863479|entityMap^0|0|0|B|5|L|17|23|18|0|8|5|H|1M|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]|$I|V|J|W|K|L]|$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@$I|10|J|11|K|L]|$I|12|J|13|K|L]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$]]

Try this

<pre><code>db.collection.update(
 { _id : ObjectId("57315ba4846dd82425ca2408")},
 { $pull: {"myarray.userId": ObjectId("570ca5e48dbe673802c2d035")}}
)
db.collection.update(
 { _id : ObjectId("57315ba4846dd82425ca2408")},
 { $push: {"myarray": {
 userId:ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }}
)
</code></pre>

Explination: 
in the first statment <code>$pull</code> removes the element with <code>userId= ObjectId("570ca5e48dbe673802c2d035")</code> from the array on the document where <code>_id = ObjectId("57315ba4846dd82425ca2408")</code>

In the second one <code>$push</code> inserts 
this object <code>{ userId:ObjectId("570ca5e48dbe673802c2d035"), point: 10 }</code> in the same array.

blocks|key|1863518|text|费舍尔接受的答案是，现有的记录将首先被删除，然后再被推送。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1863519|一种更安全的方法(常识)是尝试首先更新记录，如果没有找到匹配的记录，就插入它，如下所示：|1863520|//+first+try+to+overwrite+existing+value
var+result+=+db.collection.update(
+++{
+++++++_id+:+ObjectId("57315ba4846dd82425ca2408"),
+++++++"myarray.userId":+ObjectId("570ca5e48dbe673802c2d035")
+++},
+++{
+++++++$set:+{"myarray.$.point":+{point:+10}}
+++}
);
//+you+probably+need+to+modify+the+following+if-statement+to+some+async+callback
//+checking+depending+on+your+server-side+code+and+mongodb-driver
if(!result.nMatched)
{
++++//+record+not+found,+so+create+a+new+entry
++++//+this+can+be+done+using+$addToSet:
++++db.collection.update(
++++++++{
++++++++++++_id:+ObjectId("57315ba4846dd82425ca2408")
++++++++},
++++++++{
++++++++++++$addToSet:+{
++++++++++++++++myarray:+{
++++++++++++++++++++userId:+ObjectId("570ca5e48dbe673802c2d035"),
++++++++++++++++++++point:+10
++++++++++++++++}
++++++++++++}
++++++++}
++++);
++++//+OR+(the+equivalent)+using+$push:
++++db.collection.update(
++++++++{
++++++++++++_id:+ObjectId("57315ba4846dd82425ca2408"),
++++++++++++"myarray.userId":+{$ne:+ObjectId("570ca5e48dbe673802c2d035"}}
++++++++},
++++++++{
++++++++++++$push:+{
++++++++++++++++myarray:+{
++++++++++++++++++++userId:+ObjectId("570ca5e48dbe673802c2d035"),
++++++++++++++++++++point:+10
++++++++++++++++}
++++++++++++}
++++++++}
++++);
}|code-block|syntax|javascript|1863521|这也会提高性能(常识，未经测试)，如果在大多数情况下记录已经存在，则只执行第一个查询。|1863522|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The accepted answer by Flying Fisher is that the existing record will first be deleted, and then it will be pushed again.

A safer approach (common sense) would be to try to update the record first, and if that did not find a match, insert it, like so:

<pre><code>// first try to overwrite existing value
var result = db.collection.update(
 {
 _id : ObjectId("57315ba4846dd82425ca2408"),
 "myarray.userId": ObjectId("570ca5e48dbe673802c2d035")
 },
 {
 $set: {"myarray.$.point": {point: 10}}
 }
);
// you probably need to modify the following if-statement to some async callback
// checking depending on your server-side code and mongodb-driver
if(!result.nMatched)
{
 // record not found, so create a new entry
 // this can be done using $addToSet:
 db.collection.update(
 {
 _id: ObjectId("57315ba4846dd82425ca2408")
 },
 {
 $addToSet: {
 myarray: {
 userId: ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }
 }
 }
 );
 // OR (the equivalent) using $push:
 db.collection.update(
 {
 _id: ObjectId("57315ba4846dd82425ca2408"),
 "myarray.userId": {$ne: ObjectId("570ca5e48dbe673802c2d035"}}
 },
 {
 $push: {
 myarray: {
 userId: ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }
 }
 }
 );
}
</code></pre>

This should also give (common sense, untested) an increase in performance, if in most cases the record already exists, only the first query will be executed.

blocks|key|1109585|text|当您想要在数组中更新或插入值时，尝试它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1109586|对象在db中。|1109587|key:name,
key1:name1,
arr:[
++++{
++++++++val:1,
++++++++val2:1
++++}
]|code-block|syntax|javascript|1109588|查询|1109589|var+query+=+{
++++$inc:{
++++++++"arr.0.val":+2,
++++++++"arr.0.val2":+2
++++}
}
.updateOne(+{+"key":+name+},+query,+{+upsert:+true+}

key:name,
key1:name1,
arr:[
++++{
++++++++val:3,
++++++++val2:3
++++}
]|1109590|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

When you want update or insert value in array try it

Object in db

<pre><code>key:name,
key1:name1,
arr:[
 {
 val:1,
 val2:1
 }
]
</code></pre>

Query

<pre><code>var query = {
 $inc:{
 "arr.0.val": 2,
 "arr.0.val2": 2
 }
}
.updateOne( { "key": name }, query, { upsert: true }

key:name,
key1:name1,
arr:[
 {
 val:3,
 val2:3
 }
]
</code></pre>

blocks|key|958368|text|在MongoDB+3.6中，现在可以使用在数组中重新插入元素了。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|958369|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.mongodb.com/manual/reference/operator/update/positional-filtered/#upsert^0|K|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

In MongoDB 3.6 it is now possible to <a href="https://docs.mongodb.com/manual/reference/operator/update/positional-filtered/#upsert" rel="nofollow noreferrer">upsert elements in an array</a>.

blocks|key|1863622|text|我还没有找到任何基于一个原子查询的解决方案。相反，有三种基于两个查询序列的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1863623|总是$pull+(从数组中删除项)，然后是$push+(将更新的项添加到数组中)
db.collection.update(+{+_id+:+ObjectId("57315ba4846dd82425ca2408")}，{+$pull：{"myarray.userId"：ObjectId("570ca5e48dbe673802c2d035")}}+db.collection.update(+{+_id+:ObjectId(“57315ba4846dd82525ca2408”)}，{+$push：{+"myarray"：{+userId:ObjectId("570ca5e48dbe673802c2d035")，点:+10+}})|ordered-list-item|offset|length|style|CODE|1863624|尝试$set+(如果存在则更新数组中的项)，然后获取结果并检查更新操作是否成功或是否需要$push+(插入项)
db.collection.update(+{+_id+:+ObjectId("57315ba4846dd82425ca2408")，"myarray.userId"：ObjectId("570ca5e48dbe673802c2d035")+}，{+$set：{"myarray.$.point"：{point:+10}}；if(!result.nMatched){+db.collection.update({_id:+ObjectId("57315ba4846dd82425ca2408")}，{+$addToSet：{+myarray：{+userId:+ObjectId("570ca5e48dbe673802c2d035")，点:+10+}+)；|1863625|始终为$addToSet+(如果不存在则添加项)，然后始终使用$set来更新数组中的项
db.collection.update({_id:+ObjectId("57315ba4846dd82425ca2408")}，myarray：{+$not：{+$elemMatch：{userId:+ObjectId("570ca5e48dbe673802c2d035")}+}+}，{+$addToSet：{+myarray：{+userId:+ObjectId("570ca5e48dbe673802c2d035")，点:+10+}+}，{Multi-：false，10:+false})；db.collection.update({+_id:+ObjectId("57315ba4846dd82425ca2408")，"myArray.userId"：ObjectId("570ca5e48dbe673802c2d035")+}，{+$set：{+myArray.$.point:+10+}，{+multi:+false，10:false}；|1863626|第一和第二种方式是不安全的，因此必须建立事务以避免两个并发请求push相同的项生成一个副本。|BOLD|1863627|第三条路更安全。只有当项目不存在时，$addToSet才会添加，否则什么都不会发生。在两个并发请求的情况下，只有一个请求将缺失的项添加到数组中。|1863628|entityMap^0|0|2|5|L|5|0|2|4|18|5|0|3|9|V|4|0|9|4|V|4|0|I|9|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@$E|V|F|W|G|H]|$E|X|F|Y|G|H]]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@$E|10|F|11|G|H]|$E|12|F|13|G|H]]|9|@]|A|$]]|$1|K|3|L|5|D|7|14|8|@$E|15|F|16|G|H]|$E|17|F|18|G|H]]|9|@]|A|$]]|$1|M|3|N|5|6|7|19|8|@$E|1A|F|1B|G|O]|$E|1C|F|1D|G|H]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@$E|1F|F|1G|G|H]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|S|$]]

I haven't found any solutions based on a one atomic query. Instead there are 3 ways based on a sequence of two queries:

<ol>
<li>always <code>$pull</code> (to remove the item from array), then <code>$push</code> (to add the updated item to array)

<pre><code>db.collection.update(
 { _id : ObjectId("57315ba4846dd82425ca2408")},
 { $pull: {"myarray.userId": ObjectId("570ca5e48dbe673802c2d035")}}
)

db.collection.update(
 { _id : ObjectId("57315ba4846dd82425ca2408")},
 {
 $push: {
 "myarray": {
 userId:ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }
 }
 }
)
</code></pre></li>
<li>try to <code>$set</code> (to update the item in array if exists), then get the result and check if the updating operation successed or if a <code>$push</code> needs (to insert the item)

<pre><code>var result = db.collection.update(
 {
 _id : ObjectId("57315ba4846dd82425ca2408"),
 "myarray.userId": ObjectId("570ca5e48dbe673802c2d035")
 },
 {
 $set: {"myarray.$.point": {point: 10}}
 }
 );

if(!result.nMatched){
 db.collection.update({_id: ObjectId("57315ba4846dd82425ca2408")},
 {
 $addToSet: {
 myarray: {
 userId: ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }
 }
 );
</code></pre></li>
<li>always <code>$addToSet</code> (to add the item if not exists), then always <code>$set</code> to update the item in array

<pre><code> db.collection.update({_id: ObjectId("57315ba4846dd82425ca2408")},
 myarray: { $not: { $elemMatch: {userId: ObjectId("570ca5e48dbe673802c2d035")} } } },
 { 
 $addToSet : {
 myarray: {
 userId: ObjectId("570ca5e48dbe673802c2d035"),
 point: 10
 }
 }
 },
 { multi: false, upsert: false});

 db.collection.update({
 _id: ObjectId("57315ba4846dd82425ca2408"),
 "myArray.userId": ObjectId("570ca5e48dbe673802c2d035")
 },
 { $set : { myArray.$.point: 10 } },
 { multi: false, upsert: false});
</code></pre></li>
</ol>

1st and 2nd way are unsafe, so transaction must be established to avoid two concurrent requests could <code>push</code> the same item generating a duplicate.

3rd way is safer. the <code>$addToSet</code> adds only if the item doesn't exist, otherwise nothing happens. In case of two concurrent requests, only one of them adds the missing item to the array.

blocks|key|1109717|text|数组更新和创建不要混合在一个查询下，如果您非常关心原子性，那么就有以下解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1109718|规范你的模式，|1109719|{
++++"_id"+:+ObjectId("57315ba4846dd82425ca2408"),
++++userId+:+ObjectId("570ca5e48dbe673802c2d035"),
++++point+:+5
}|code-block|syntax|javascript|1109720|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

array update and create don't mix in under one query, if you care much about atomicity then there's this solution:

normalise your schema to,

<pre><code>{
 "_id" : ObjectId("57315ba4846dd82425ca2408"),
 userId : ObjectId("570ca5e48dbe673802c2d035"),
 point : 5
}
</code></pre>

blocks|key|1863680|text|有一个名为使用聚合管道更新文档的选项，从MongoDB+v4.2开始，|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1863681|检查条件$cond是否userId在myarray.userId中|unordered-list-item|CODE|1863682|如果是，则$map迭代myarray数组的循环并检查userId是否匹配，然后使用$mergeObjects与新文档合并。|1863683|如果否，则$concatArrays连接新对象和myarray|1863684|let+_id+=+ObjectId("57315ba4846dd82425ca2408");
let+uodateDoc+=+{
++userId:+ObjectId("570ca5e48dbe673802c2d035"),
++point:+10
};

db.collection.update(
++{+_id:+_id+},
++[{
++++$set:+{
++++++myarray:+{
++++++++$cond:+[
++++++++++{+$in:+[updateDoc.userId,+"$myarray.userId"]+},
++++++++++{
++++++++++++$map:+{
++++++++++++++input:+"$myarray",
++++++++++++++in:+{
++++++++++++++++$mergeObjects:+[
++++++++++++++++++"$$this",
++++++++++++++++++{
++++++++++++++++++++$cond:+[
++++++++++++++++++++++{+$eq:+["$$this.userId",+updateDoc.userId]+},
++++++++++++++++++++++uodateDoc,
++++++++++++++++++++++{}
++++++++++++++++++++]
++++++++++++++++++}
++++++++++++++++]
++++++++++++++}
++++++++++++}
++++++++++},
++++++++++{+$concatArrays:+["$myarray",+[uodateDoc]]+}
++++++++]
++++++}
++++}
++}]
)|code-block|syntax|javascript|1863685|游乐场|1863686|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.mongodb.com/manual/tutorial/update-documents-with-aggregation-pipeline/|1|https://mongoplayground.net/p/pd4YRqwdo3S^0|K|C|5|A|0|0|4|5|B|6|I|E|0|5|4|B|7|Q|6|15|D|0|5|D|O|7|0|0|0|3|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@$9|17|A|18|1|19]]|E|$]]|$1|F|3|G|5|H|7|1A|8|@$9|1B|A|1C|B|I]|$9|1D|A|1E|B|I]|$9|1F|A|1G|B|I]]|D|@]|E|$]]|$1|J|3|K|5|H|7|1H|8|@$9|1I|A|1J|B|I]|$9|1K|A|1L|B|I]|$9|1M|A|1N|B|I]|$9|1O|A|1P|B|I]]|D|@]|E|$]]|$1|L|3|M|5|H|7|1Q|8|@$9|1R|A|1S|B|I]|$9|1T|A|1U|B|I]]|D|@]|E|$]]|$1|N|3|O|5|P|7|1V|8|@]|D|@]|E|$Q|R]]|$1|S|3|T|5|6|7|1W|8|@]|D|@$9|1X|A|1Y|1|1Z]]|E|$]]|$1|U|3|-4|5|6|7|20|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]|12|$5|X|Y|Z|E|$10|13]]]]

There is a option called <a href="https://docs.mongodb.com/manual/tutorial/update-documents-with-aggregation-pipeline/" rel="noreferrer">update documents with aggregation pipeline</a> starting from MongoDB v4.2,
<ul>
<li>check condition <code>$cond</code> if <code>userId</code> in <code>myarray.userId</code> or not</li>
<li>if yes then <code>$map</code> to iterate loop of <code>myarray</code> array and check condition if <code>userId</code> match then merge with new document using <code>$mergeObjects</code></li>
<li>if no then <code>$concatArrays</code> to concat new object and <code>myarray</code></li>
</ul>
<pre><code>let _id = ObjectId(&quot;57315ba4846dd82425ca2408&quot;);
let uodateDoc = {
 userId: ObjectId(&quot;570ca5e48dbe673802c2d035&quot;),
 point: 10
};

db.collection.update(
 { _id: _id },
 [{
 $set: {
 myarray: {
 $cond: [
 { $in: [updateDoc.userId, &quot;$myarray.userId&quot;] },
 {
 $map: {
 input: &quot;$myarray&quot;,
 in: {
 $mergeObjects: [
 &quot;$$this&quot;,
 {
 $cond: [
 { $eq: [&quot;$$this.userId&quot;, updateDoc.userId] },
 uodateDoc,
 {}
 ]
 }
 ]
 }
 }
 },
 { $concatArrays: [&quot;$myarray&quot;, [uodateDoc]] }
 ]
 }
 }
 }]
)
</code></pre>
<a href="https://mongoplayground.net/p/pd4YRqwdo3S" rel="noreferrer">Playground</a>

blocks|key|1863726|text|您可以使用我目前在mongosh中使用的..forEach/..updateOne方法的一个变体来做这样的事情。在.forEach中，您可能能够设置您提到的所有if/条件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1863727|示例..forEach/..updateOne：|1863728|let+medications+=+db.medications.aggregate([
++{$match:+{patient_id:+{$exists:+true}}}
]).toArray();

medications.forEach(med+=>+{
++try+{
++++db.patients.updateOne({patient_id:+med.patient_id},+
++++++{$push:+{medications:+med}}
++++)
++}+catch+{
++++console.log("Didn't+find+match+for+patient_id.++Could+not+add+this+med+to+a+patient.")
++}++
})|code-block|syntax|javascript|1863729|这可能不是最"MongoDB“的方法，但它确实有效，并使您可以自由使用javascript在.forEach中进行操作。|1863730|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/54591042/mongodb-4-0-aggregation-addfields-not-saving-documents-after-using-todate/69429447#69429447^0|1L|8|K|N|0|0|0|O|0|0|1A|8|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|15|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|O|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

You could use a variation of the <a href="https://stackoverflow.com/questions/54591042/mongodb-4-0-aggregation-addfields-not-saving-documents-after-using-todate/69429447#69429447">.forEach/.updateOne method</a> I currently use in mongosh CLI to do things like that. In the .forEach, you might be able to set all of your if/then conditions that you mentioned.
Example of .forEach/.updateOne:
<pre><code>let medications = db.medications.aggregate([
 {$match: {patient_id: {$exists: true}}}
]).toArray();

medications.forEach(med =&gt; {
 try {
 db.patients.updateOne({patient_id: med.patient_id}, 
 {$push: {medications: med}}
 )
 } catch {
 console.log(&quot;Didn't find match for patient_id. Could not add this med to a patient.&quot;)
 } 
})
</code></pre>
This may not be the most &quot;MongoDB way&quot; to do it, but it definitely works and gives you the freedom of javascript to do things within the .forEach.

blocks|key|1863745|text|使用聚合管道的可能解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1863746|db.collection.update(
++++++{+_id+},
++++++[
++++++++{
++++++++++$set:+{
++++++++++++myarray:+{+$filter:+{
++++++++++++++input:+'$myarray',
++++++++++++++as:+'myarray',
++++++++++++++cond:+{+$ne:+['$$myarray.userId',+ObjectId('570ca5e48dbe673802c2d035')]+},
++++++++++++}+},
++++++++++},
++++++++},
++++++++{
++++++++++$set:+{
++++++++++++myarray:+{
++++++++++++++$concatArrays:+[
++++++++++++++++'$myarray',
++++++++++++++++[{+userId:+ObjectId('570ca5e48dbe673802c2d035'),+point:+10+},
++++++++++++++++],
++++++++++++++],
++++++++++++},
++++++++++},
++++++++},
++++++],
++++);|code-block|syntax|javascript|1863747|我们使用两个阶段：|1863748|过滤器myarray+(=删除元素，如果存在userId+)|ordered-list-item|offset|length|style|CODE|1863749|用新元素级联过滤后的myarray；|1863750|entityMap^0|0|0|0|3|7|M|6|0|A|7|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|W|8|@$L|X|M|Y|N|O]|$L|Z|M|10|N|O]]|9|@]|A|$]]|$1|P|3|Q|5|K|7|11|8|@$L|12|M|13|N|O]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|S|$]]

Possible solution with aggregation pipeline:
<pre><code>db.collection.update(
 { _id },
 [
 {
 $set: {
 myarray: { $filter: {
 input: '$myarray',
 as: 'myarray',
 cond: { $ne: ['$$myarray.userId', ObjectId('570ca5e48dbe673802c2d035')] },
 } },
 },
 },
 {
 $set: {
 myarray: {
 $concatArrays: [
 '$myarray',
 [{ userId: ObjectId('570ca5e48dbe673802c2d035'), point: 10 },
 ],
 ],
 },
 },
 },
 ],
 );
</code></pre>
We use 2 stages:
<ol>
<li>filter <code>myarray</code> (= remove element if <code>userId</code> exist)</li>
<li>concat filtered <code>myarray</code> with new element;</li>
</ol>

I have the following collection
<pre><code>{
 &quot;_id&quot; : ObjectId(&quot;57315ba4846dd82425ca2408&quot;),
 &quot;myarray&quot; : [ 
 {
 userId : ObjectId(&quot;570ca5e48dbe673802c2d035&quot;),
 point : 5
 },
 {
 userId : ObjectId(&quot;613ca5e48dbe673802c2d521&quot;),
 point : 2
 }, 
 ]
}
</code></pre>
<h3>These are my questions</h3>
I want to push into <code>myarray</code> if <code>userId</code> doesn't exist, it should be appended to <code>myarray</code>. If <code>userId</code> exists, it should be updated to point.
<h3>I found this</h3>
<pre><code>db.collection.update({
 _id : ObjectId(&quot;57315ba4846dd82425ca2408&quot;),
 &quot;myarray.userId&quot; : ObjectId(&quot;570ca5e48dbe673802c2d035&quot;)
}, {
 $set: { &quot;myarray.$.point&quot;: 10 }
})
</code></pre>
But if <code>userId</code> doesn't exist, nothing happens.
<h3>and</h3>
<pre><code>db.collection.update({
 _id : ObjectId(&quot;57315ba4846dd82425ca2408&quot;)
}, {
 $push: {
 &quot;myarray&quot;: {
 userId: ObjectId(&quot;570ca5e48dbe673802c2d035&quot;),
 point: 10
 }
 }
})
</code></pre>
But if <code>userId</code> object already exists, it will push again.
What is the best way to do this in MongoDB?

MongoDB - Update or Insert object in array

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有以下收藏{    "_id" : ObjectId("57315ba4846dd82425ca2408"),    "myarray" : [         {            userId : ObjectId("570ca5e48dbe673802c2d035"),            point :...

问MongoDB -在数组中更新或插入对象
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MongoDB -在数组中更新或插入对象EN