Spring Data Mongo API for findAndModify conditional criteria
I have a Mongo query like this:
db.account_balances.findAndModify({
query: { _id: '1234' },
update: [
{
$set: {
'fieldToUpdate': {
$cond: {
if: {
$and: [
{ $lte: ['$updatedAt', new ISODate('2024-09-24T00
0000.000Z')] },
{ $lt: [ { $toLong: '$numericalStringField' }, 1000 ] }
],
},
then: 15000.0,
else: '$fieldToUpdate'
}...