HTML5 Data Bindings Support Product Page


Select distinct records

Asked 20 Dec 2013 07:19:24
have this question
20 Dec 2013 07:19:24 Graeme Beaty posted:
Is there a way to select distinct records only?


Replied 20 Dec 2013 12:42:25
20 Dec 2013 12:42:25 Teodor Kuduschiev replied:
Hi Graeme,
Can you please provide a little more detailed information about what you need to achieve? An example also will be good
Replied 20 Dec 2013 16:13:27
20 Dec 2013 16:13:27 Graeme Beaty replied:

I have a table containing multiple columns and I wish to obtain distinct records from one column e.g.

columns: id, address, city
Table contains 7 entries with different id but only 2 cities in all 7 entries i.e. 5 x Madrid 2 x London
I just want to obtain the list of the two cities
With a regular mySQL expression you just simply state select distinct city.tablename from tablename


Replied 09 Oct 2014 00:54:34
09 Oct 2014 00:54:34 Steve Skinner replied:
Me too! I need to do this as well. I have a database table which contains lots of labels. I want to generate a list of these labels from a certain field in the table, but I don't want to show duplicates (select DISTINCT it would be in SQL as Graeme has pointed out).

I guess in the mean time I could just create an SQL query to do that and then use the query with HTML5 DB...
Replied 24 Oct 2014 12:58:02
24 Oct 2014 12:58:02 Teodor Kuduschiev replied:
Unfortunately distinct is not supported in the current version of the extension. I'm adding this into the wishlist for the upcoming updates.
Replied 26 Nov 2014 01:17:41
26 Nov 2014 01:17:41 Baub Eis replied:
Isn't this the same as the "group by" in the Data Bindings Formatter extension?

Reply to this topic