Hi, I am trying to convert the below update pipeline upsert query to spring boot MongoTemplate upsert. how can I achieve that ?
var id = {"empId":1};
var item = { sequenceNumber: "5", Code: "CODEtsKEt"};
db.member.update(
id,
[{
$set: {
enrollment: {
$cond: [
{
$in: [item.sequenceNumber, { $ifNull: ["$enrollment.sequenceNumber", []] }]
},
{
$map: {
input: "$enrollment",
in: {
$mergeObjects: [
"$$this",
{
$cond: [{ $eq: ["$$this.sequenceNumber", "5"] }, item, {}]
}
]
}
}
},
{
$concatArrays: [{ $ifNull: ["$enrollment", []] }, [item]]
}
]
}
}
}],
{ upsert: true }
);