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
Thank you for your suggestion. The ability to display distinct records in reports is a standard feature in all Report DataPages.
-
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.