Skip to main content
Version: Streamsheets 2.4

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

NameDescription
ProducerProducer to use for counting. The database name is configured in the affiliated Connector.
CollectionChoose an existing collection, where the item is stored.
QueryDefine a query using a JSON cell range, which defines the object(s) to be counted.
TargetINBOX(), 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.
TimeoutOptional. Define Timeout.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=MONGO.COUNT(|Producer, "TestCollection", JSON(A1:B4))TRUE