I need to perform an insert/update operation (upsert) on a document.
In the snippet below, there is a syntactical error, but this is what I am attempting to achieve:
$inc: { {type=="profileCompletion"?"profileCompletion":"matchNotification"}: 1},
If the type (received in req.body) is profileCompletion, I want the document to look like this:
{
"_id": "0h4wpbgy7u",
"date": "Oct242022",
"profileCompletion": 1,
"matchNotification": 0
}
Below is the current query I have:
await db.collection('emails')
.updateOne(
{
_id: userId
},
{
$setOnInsert:
{
time: getDateMonYear(new Date()),
},
$inc: { {type=="profileCompletion"?"profileCompletion":"matchNotification"}: 1},
},
{upsert: true},
)