[SOLVED] Summerize or Categorize in a List

Hi, I am wanting to do the following...

I have a field called 'university' with either selectable or dropdown choices of

• university 1
• university 2
• university 3
• etc.

Lets say there are 20 members that select 'university 1' and 10 that select 'university 2' and none that select 'university 3'.

When I make a list that will only show the university field it will show 20 lines of 'university 1' then 10 lines of 'university 2' and naturally none of 'university 3'. Is there a way to make it so it shows on one line (a summary) of 'university 1' and only line of 'university 2'.

My thoughts for this would be if the university was a category & the list would only show available or active categories.

Is what I am taking about possible, please don't reply with a simple 'no'

You want your userlist to display only users who have selected a specific university? Like a userlist to display only the users who selected "University 1" for example? If that's what you're wanting yes it's doable. You'll need to edit your userlist within CB > List Management then add a Basic filter of "University Like %University 1%" for example.

Thank you for the reply but that still shows multiple listings of the same university where as I need the university's summerised. At the moment they are showing like this...

• Charles Sturt University
• Charles Sturt University
• Curtin University
• Curtin University
• Curtin University
• Flinders University
• Flinders University

Where as I need them to show like this...

• Charles Sturt University
• Curtin University
• Flinders University

With no repeat entries.

You only want to show 1 user per university? I'm sorry, but I don't understand what you're wanting.

Yes I have other lists showing all the members and all their details, but I want this list to only show a short list of the universities.

Here is the Full List View

Here is the Short List Example , so every time my client adds in a new user and that user may belong to a new university then only one listing of that uni will show.

I see, no you can't do that with a userlist. There's no way to add to the userlist query the needed GROUP BY without developing a CB plugin to alter the userlist query. I suppose you could try adding a WHERE statement and do a IN check against a subquery of grouped user ids, but that's going to be inefficient and slow the more users you have.