ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Big Data / Managing Mongo files
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Modifies a document in a collection of MongoDB database.
Example
let sFilter = "{ ""name"": ""Andy"" }"
let sModification = "{ ""$inc"": { ""score"": 1 } }"
let d = MongoModifyOne(Collection, sFilter, sModification)
// Find the first contact whose "FirstName" member is set to "Jack" and modify it to "Joey"
// Search filter
sFilter is string = "{ ""FirstName"": ""Jack"" }"
// Modification criterion
sModification is string = "{ ""$set"": {""FirstName"": ""Joey"" } }"
MongoModifyOne(gclCollection, sFilter, sModification)
Syntax
<Result> = MongoModifyOne(<Collection> , <Filter> , <Modification> [, <Sort>] [, <Option>])
<Result>: Variant
Document before or after modification (according to the selected option).
<Collection>: mongoCollection variable
Name of the mongoCollection variable that represents the MongoDB collection in which the modification will be made.
<Filter>: Type of the filter used
Description of the MongoDB filter(s) that will be applied to select the document to update. This filter corresponds to:
  • a JSON document, in string format.
  • a BSON document, in buffer format.
  • a variant.
<Modification>: Type of the format used
Description of the modifications that will be performed in the document that matches the filter. Corresponds to:
  • a JSON document, in string format.
  • a BSON document, in buffer format.
  • a variant.
<Sort>: Optional type corresponding to the format used
Sort options used to define the first document that will be modified when several documents correspond to the filter. Corresponds to:
  • a JSON document, in string format.
  • a BSON document, in buffer format.
  • a variant.
<Option>: Optional Integer constant
Modification options:
mongoAddIfNotFoundUsed to add the document if it does not exist in the collection.
mongoReturnValueAfterUsed to return the document after modification.
By default, if this constant is not used, the document returned corresponds to the document before modification.
Related Examples:
Native access to MongoDB Unit examples (WINDEV): Native access to MongoDB
[ + ] This example shows how to use the main functions of native access to MongoDB databases: adding data, reading (searching), modifying and deleting data in the database. The example also shows functions for saving files in the MongoDB GridFS data system.
Component: wd290big.dll
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help