SQL distinct for views
Add a distinct records option to views. I'm aware of the requests at the report level, some / most of that need could be resolved if we could base that report on a view that has a "SELECT DISTINCT" enabled. Should be easy to implement?
Glenn Walters
shared this idea
-
Bill Pennock
commented
Planned as of September21 2021. That's a long time to sit in the todo column of agile
-
Landonia of Garland
commented
I believe this feature has been implemented at this point if I'm not mistaking and reading this correctly =>
-
Matt Parkan commented
This is an essential feature. We are currently loosing a lot of time to figure out a workaround just because this simple feature is missing. Also note this request has been made multiple times:
http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/37492510-sql-distinct-for-views
-
This is an essential feature. We are currently loosing a lot of time to figure out a workaround just because this simple feature is missing. Also note this request has been made multiple times:
http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/37492510-sql-distinct-for-views
-
Walt
commented
Joining 2 tables in Views needs a check box for "distinct" which would remove all duplicate records. This would allow the views to be easily used in tabular reports.
"Distinct" is an important keyword in the underlying SQL Select command that should be easily added by Caspio. I have never needed an SQL Select without the "distinct" keyword in my programming experience.
Views with no duplicate records could allow productive views created with other views as the data source. This should allow data to be filtered and messaged in almost any way which may reduce the need for all of the complex options inside of the Datapage builders.
-
Kathryn Hall
commented
Instead of filtering by duplicates, I would like to return only the unique values - that is, I would like to hide the duplicates and show only the unique values for a particular field (this would be the inverse of the current "filter by duplicates" option).