Hi
I'm using mongo and I want to run a distinct query.?
Any ideas?
I see the option Action Type Distinct in the query builder I don't know what format the query JSON should be.
Thank you
Jamie
Hi
I'm using mongo and I want to run a distinct query.?
Any ideas?
I see the option Action Type Distinct in the query builder I don't know what format the query JSON should be.
Thank you
Jamie
More info.
This is the query section. The action type Distinct for MongoDB.
How do we use the query section to specify what we want distinct?
Hi @Jamie_Good
Thanks for reaching out. The distinct requires, at a minimum, a string value for the column that you want to get the distinct values for --
In this example, I am searching for distinct property_type
values
In this example, I've added a query
to filter down for only records that have property_type
Apartment. Then, I'm querying for the distinct room_types
Let us know if you want to chat further about your specific use case