When I execute queries I want to be able to get all distinct values from a table. Let’s say I just want to get all unique customers from a orders table. Then .distinct(“customer_name”) would be a perfect addition to the wix-data collection of things.
2 Likes
I am also looking how to get distinct values from a table field.
Coming soon
Hurray
Hopefully Soon
Is this already possible? Also would need it for my website I’m creating…
WHEN???
any updates on this? I see .distinct in the api reference, but get an error when i try to use it.
The .distinct() query function is available. See the .distinct() API documentation for information.
See the following example to see how it’s used…
Remove Dropdown Duplicates
Remove duplicates from connected dropdown options.
HI,
I would use it with wixData.aggregate(“collection”)
Thanks
Hi all, how can “distinct” be applied to a .setfilter and not to a query?
I need to apply it to a repeater in a page.
Thanks