Select Distinct - how?

Mr_English

Hello

Can someone point me to the feature that will enable me to select the distinct values of a query filter, such as:

[

{"recipientID":538},

{"recipientID":538},

{"recipientID":411},

{"recipientID":533},

{"recipientID":538}

]

Distinct would return:

[

{"recipientID":538},

{"recipientID":411},

{"recipientID":533}

]

I've checked in the Output page, but nothing seems to do the job.
I have seen Distinct Records select, but I don't know what it does.

Thanks.

jwhitlock

Sounds like the Unique filter is what you're looking for. https://docs.xano.com/working-with-data/data-type-filters/array-filter#unique

Mr_English

@jwhitlock Thanks! Yes I got it the next day - I thought it would have the same name as the SQL operator. The link you sent is useful. Still not sure what the Distinct Records select in the Output area is for though - @Michael Udinski could you shed light on this?