Mongo Distinct query - how to do it?

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

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 :blush: