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.ReplaceOne

This replace one document in the collection that match selector with replacement.

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

Parameters

Parameter Description Example
MongoDBRef The reference number for the mongo connection. $MongoDB
selectorJSON A JSON containing the query to match the document for updating.
updateJSON A JSON containing the replacement document.

Result

Returns JSON or error.

Description

This replace one document in the collection that match selector with replacement.
Returns the reply JSON is populated with the fields matchedCount, modifiedCount, upsertedCount, 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

Replace one record:

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" ) ]
# replace a record with a new JSON
Set Variable [ $r ; Value: MBS( "MongoDB.ReplaceOne"; $Mongo; "{\"Hello\": \"World\"}"; "{\"Hello\": \"World\", \"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 13th June 2022


MongoDB.Rename - MongoDB.ServerDescription

Feedback: Report problem or ask question.


Start Chat