MongoDB Connected System

• Version 1.4.0, includes new Bulk Write Integration (contributed by Vuram SWAT) allowing for many write operations to be executed in one process node.

Hi, we are upgrading our MongoDB version from 4.4 to 6. Are there any issues regarding the usage of the plug-in?

How to use mongo db syntax in appian "db.students2.updateOne({ },{ $set: { "grades.$[elem].mean" : 100 } },{ arrayFilters: [ { "elem.grade": { $gte: 85 } } ] })"

Error received: Error code 2: No array filter found for identifier 'elem' in path.

hi all,
while using this plugin to find matching records for given date condition am getting an error.
please find my code below and kindly help me resolve this issue: 

a!toJson({

{'$match': {

'ruleUuid': {
'$in': {ri!ruleUuid}
},
'dQExecutionDate': {
'$gt' : ISODate (ri!fromDate)
}

}}
})

Without ISODate object who can we apply filter on date field? Is there any other approach?

• Bug fix in M_Query()

• Minor bug fixes; security updates

• Fixed a bug in M_Eq() where Appian TypedValues were not being handled correctly

I will take a look at this and submit an update asap.

For now you can work around it by constructing the JSON via standard expressions. Tip: to use special characters in Dictionary key names, surround the value with single-quotes like so:

a!toJson({ status: { '$eq': "Completed" } })

Dear Team,

While testing this plugin we could see that the filter Collection  type on the field does not work correctly.. here is an example:

Input

m_query(
  {
    m_field(
    "status",
    m_eq(
      "Completed"
    )
  )
  }
)

Expected : "{ "status": { "$eq": "Completed" } }"

Actual : "{ "status": { "$eq": "TypedValue[it=3,v=Completed]" } }"

Any idea why the text "TypedValue[it=3,v=" is getting added to the request while making call to MongoDB ?