Was this helpful?
Was this helpful?
The is a non-relational database, which means its commands and processes differ from those commonly used in relational databases. This article explains how to:
Group identical items in the Object Store (similar to the DISTINCT
command in relational databases).
Count the number of stored objects.
To group and retrieve unique values in the Object Store connector:
In Operation, select Aggregate.
In Query, use the following command, replacing "$price"
with the field you want to group by:
This operation outputs only the unique values. For example:
To count the total number of records in the Object Store:
In Operation, select Aggregate.
In Query, use the following command:
This operation returns the total number of records stored in the Object Store.
For further details, refer to the connector documentation.
Learn how to group and count items using the Object Store connector.