How to get DISTINCT values from a data table column using queries in the API call with data-tables/rows/query?
After some discussion with the engineering team,
DISTINCT isn’t currently an operation we support for Data Tables. What I can do is make a feature request for this, and let you know if it gets released!
Depending on your use case, you could access MYSQL ( or any other SQL ) DB in a workflow. It would give you the ability to have more query power but does require you to have/maintain an instance of a SQL database.
Thanks, that will be a good feature to have.
In the meantime, I will get all rows and loop through to get distinct values.