CiviCRM Community Forums (archive)

Hi,

I'm using the Views3 module on Drupal 7.22 with CiviCRM 4.33
I'm trying to create a simple list of all groups, sorted ascending on group title.

When I specify the title a sorting criteria, the generated query still sorts on ID
I also noticed that while I select to show the fields 'ID' and 'Title', the genertaed query shows
"SELECT DISTINCT civicrm_group.id AS id, civicrm_group.id AS civicrm_group_id
FROM
{civicrm_group} civicrm_group"

I'm not really into programming these kind of things so I don't really have an idea where exactly to look.

Maybe interesting to add is that this used to work well in CiviCRM 4.2.
The only issue I had with this view was not being able to filter on Group Title, but only on group_id. A bit of work to configure when you need to filter on a number of groups, but less anoying than a sort that does not work.