Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2   12.3   12.4    Statistic    FMM    Blog  

MongoDB.UpdateMany

Updates many documents in collection that matches selector.

Component Version macOS Windows Linux Server iOS SDK
MongoDB 12.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "MongoDB.UpdateMany"; MongoDBRef; selectorJSON; updateJSON { ; OptionsJSON } )   More

Parameters

Parameter Description Example Flags
MongoDBRef The reference number for the mongo connection. $MongoDB
selectorJSON A JSON containing the query to match documents for updating.
updateJSON A JSON containing the update to perform. If updating with a pipeline, a JSON array.
OptionsJSON Options as JSON. Optional

Result

Returns OK or error.

Description

Updates many documents in collection that matches selector.
To update at most one document see UpdateOne().
The result JSON is filled out with fields matchedCount, modifiedCount, and optionally upsertedId if applicable. If there is a server error then reply contains either a “writeErrors” array with one subdocument or a “writeConcernErrors” array.

Examples

Update many records:

Set Variable [ $Mongo ; Value: MBS( "MongoDB.New" ) ]
Set Variable [ $r ; Value: MBS( "MongoDB.SetURI"; $Mongo; "mongodb://localhost/" ) ]
Set Variable [ $r ; Value: MBS( "MongoDB.Connect"; $Mongo) ]
Set Variable [ $r ; Value: MBS( "MongoDB.OpenDatabase"; $Mongo; "local" ) ]
Set Variable [ $r ; Value: MBS( "MongoDB.OpenCollection"; $Mongo; "test" ) ]
# update a lot of records by setting a new field
Set Variable [ $r ; Value: MBS( "MongoDB.UpdateMany"; $Mongo; "{\"Hello\": \"World\"}"; "{\"$set\": {\"OtherField\": 123}}") ]
Show Custom Dialog [ "Result" ; $r ]
Set Variable [ $r ; Value: MBS( "MongoDB.Release"; $Mongo ) ]

See also

Example Databases

Created 22nd May 2022, last changed 12nd June 2022


MongoDB.SetUserName - MongoDB.UpdateOne

Feedback: Report problem or ask question.


Start Chat