Sql DISTINCT/UNIQUE in symphony
This is an open discussion with 2 replies, filed under General.
Search
Regular datasources don't support that kind of functionality. Instead you could leverage XSLT to filter out duplicate entries:
<xsl:apply-templates select="entry[preceding-sibling::entry/unique-value != current()/unique-value]" />
You could use the Group functionality of a data source, which will group by distinct values of your text field.
Create an account or sign in to comment.
How to fetch DISTINCT/UNIQUE records from the particular symphony section using datasource.
example:-
current output:
required output: