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:
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
13.3
13.4
Statistic
FMM
Blog
Updates at most one document in collection that matches selector.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
MongoDB | 12.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameter | Description | Example | Flags |
---|---|---|---|
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 update to perform. If updating with a pipeline, a JSON array. | ||
OptionsJSON | Options to use. | Optional |
Returns JSON or error.
Update 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" ) ]
# update one record by setting a new field
Set Variable [ $r ; Value: MBS( "MongoDB.UpdateOne"; $Mongo; "{\"Hello\": \"World\"}"; "{\"$set\": {\"OtherField\": 123}}") ]
Show Custom Dialog [ "Result" ; $r ]
Set Variable [ $r ; Value: MBS( "MongoDB.Release"; $Mongo ) ]
Update or Insert:
MBS( "MongoDB.UpdateOne"; $mongo;
// we select record with ID field
JSONSetElement ( "{}" ; "ID" ; Assets::PrimaryKey ; JSONString );
// and here pass whole record including all fields we like to move
JSONSetElement ( "{}" ; "$set" ; Assets::JSON ; JSONObject );
// and here allow to insert, if record is new
JSONSetElement ( "{}" ; "upsert" ; True ; JSONBoolean ))
This function checks for a license.
Created 22nd May 2022, last changed 29th July 2022