Is it possible to obtain DISTINCT values from MySQL using this extension?

If so, how.

Thanks

Graeme

Hello Graeme,

Can you please be a little more detailed? What exactly do you need to achieve?

Teodor

I have a table where I want to select dynamic values from a column but the column has some entries the same e.g.

table (id, city)
1 - London
2 - New York
3 - New York
4- Lisbon

Obviously I only want one result for London to display not one for each id.

Hello Graeme,

This can be achieved using the group by filter (HTML5 Data Bindings Formatter)

Hello, i know its been a while but the distinct option has been added to the extension: www.dmxzone.com/go/32347/using-the-distinct-option-with-database-queries/