MONGO.COUNT

Counts the amount of elements in a Mongo database. You can use the Function Wizard for this function.

Syntax

=MONGO.COUNT(Producer, Collection, Query, Target, [Timeout])

Arguments

Name	Description
Producer	Producer to use for counting. The database name is configured in the affiliated Connector.
Collection	Choose an existing collection, where the item is stored.
Query	Define a query using a JSON cell range, which defines the object(s) to be counted.
Target	INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
Timeout (optional)	Define Timeout.

Return

TRUE, if no error.

Examples

Formula	Result	Comment
=MONGO.COUNT(|MongoProd ,A23,JSON(G26:H26),G28:G29)	TRUE	Counts all males in a collection