SQL DISTINCT - Unique records from a field or set of fields
Add an option for a DataPage to generate a list (either Gallery or List) which displays unique values only. This is the equivalent of the SQL DISTINCT command and should be capable of being filtered (unique Zip codes in a single/set of states in a list of addresses) or the unique records from a set of fields - One instance of any records with first and last name being exactly the same.
Anonymous
shared this idea
-
Bill Pennock
commented
I agree this is and essential feature If easier and faster you could add it to create view instead
-
Iaron7
commented
Why is this not implemented?
-
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
-
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 would also be needed for our application.
-
Douglas Vega commented
Ability to specify a field that might contain duplicate records in the data source, NOT AS THE NORMAL GROUPING option where all duplicates are visible but a way to remove all duplicate records but one, something similar to DISTINCT in SQL
-
Judith Espinoza
commented
Yes, this would be very helpful when creating a view with tables that have a 1 to many relationship but you only want one record to show. A distinct option like in sql would be very helpful.
-
Nick
commented
This would be especially useful in Data Pages. In my search fields, I should be able to specify that it return only Distinct records...I.E. if I have a list of City, State and Zip Codes and I wanted to return a list of distinct States for that list and then use HTML Blocks and Calculated fields to flesh out the rest of the data on the page.
-
mandar
commented
can not apply distinct to the records in result page. please add this feature.