Skip to main content
Version: Streamsheets 2.4

MONGO.QUERY

Gets data from your Mongo database. You can use the Function Wizard for this function.

Syntax

=MONGO.QUERY(Producer, Collection, QueryJSON, Target[, ResultKeys, PageSize, Page, Sort, Timeout])

Arguments

NameDescription
ProducerProducer to use for deleting. The database name is configured in the affiliated Connector.
CollectionChoose an existing collection, where the item is stored.
QueryJSONDefine a query using a JSON cell range, which defines the object(s) to searched for.
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.
ResultKeysOptional. Filter the query result.
PageSizeOptional. Number of Documents to return per page.
PageOptional. Index of page to return.
SortOptional. Sort query result ascending or descending. Use 1 and -1 to sort by creation time, or use a JSON cell range.
TimeoutOptional. Define Timeout.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=MONGO.QUERY(|Producer, "TestCollection", JSON(A1:B4), INBOX())TRUEAll documents in the database with the values from A1:B4 using the "Producer" in the collection "TestCollection" will be shown in the Inbox of the current Streamsheet.