Search

Hi

I have a datasource of entries that have a text location field and I’m trying to produce a ‘tagcloud’ for these locations.

Is there any way of filtering the entries so that only the entries with a unique ‘location’ field are pulled, ideally I’d like a count of how many occurrences there are of each.

I know that I could do this with xlst but was just weary of the performance implications, especially if there are hundreds if not thousands of entries as I need to be able to pull the most popular entries

Thanks

Nope this isn’t provided with the data source functionality in Symphony. You could write a custom data source to do this yourself since this is trivial to achieve using SQL (DISTINCT/COUNT/GROUP BY).

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details