Mongo Distinct query - how to do it?

[Jamie_Good]

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

[Jamie_Good]

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?

[Tess]

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

[Tess]

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

[Tess]

Let us know if you want to chat further about your specific use case