mongoFindOption (Type of variable)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Management of Mongo files

Properties specific to the description of mongoFindOption variables

Constants for managing MongoDB databases

MongoAdd

MongoAggregationPipeline

MongoCreate

MongoCreateCollection

MongoDB functions

MongoDB/GRIDFS databases

MongoDeleteAll

MongoDeleteCollection

MongoGridFSDeleteFile

MongoGridFSDeleteFileById

MongoGridFSGetFile

MongoGridFSGetFileById

MongoGridFSGetFileInfo

mongoCollectionOption

Properties specific to the description of mongoFindOption variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

mongoFindOption (Type of variable)

In french: mongoChercheOption

The mongoFindOption type is used to define the advanced characteristics of a search in a MongoDB database. The characteristics of this search can be defined and modified by several WLanguage properties.

Remark: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.

Versions 24 and later

This type of variable is now available for WEBDEV sites in Linux.

This type of variable is now available for WINDEV applications in Linux.

New in version 24

This type of variable is now available for WEBDEV sites in Linux.

This type of variable is now available for WINDEV applications in Linux.

This type of variable is now available for WEBDEV sites in Linux.

This type of variable is now available for WINDEV applications in Linux.

Example

MyOptions is mongoFindOption
MyOptions..Limit = 5

let MySearch = MongoFind(CntMdb..Database["CRM"]..Collection["products"], "{}", MyOptions)

Option is mongoFindOption
// Sort according to the age
Option..Sort = "{ ""age"": -1 }"

sFilter is string = "{}"
let MyResult = MongoFind(CntMdb..Database["CRM"]..Collection["Actors"], sFilter, Option)

Remarks

Properties specific to the description of mongoFindOption variables

The following properties can be used to handle the search options:

Property name	Type used	Effect

Skip	Integer	Number of skipped documents. The first document returned will be the document corresponding to this value +1.
Limit	Integer	Maximum number of documents that will be returned during the search.
Projection	Variant, Buffer or Character string	Document in JSON format (Character string), in BSON format (buffer) or variant defining the items to return.
Sort	Variant, Buffer or Character string	Document in JSON format (Character string), in BSON format (buffer) or variant defining the sort parameters. To get an ascending sort, the name of the key must be followed by ":1". To get a descending sort, the name of the key must be followed by ":-1".

Remark: These properties can be handled by using one of the following syntaxes:

<Variable name>..<Property name>
<Variable name>.<Property name>

Related Examples:

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.