CiviCRM Community Forums (archive)

Hello,

in an installation with Drupal 7.18 + CiviCRM 4.1.2 we tried to build a view with contacts, whith a filter dropdown for groups.
We are able to design the view an the filter dropdown, but the produced SQL statement is incorrect, so the filter doesn't work

The filter criteria in the Drupal view is
CiviCRM Contacts: Contact Type (= Individual)
CiviCRM Groups: Titel (exposed)

The group with title 'Seniors' has id 11

The procuced SQL filter for this group
WHERE (( (civicrm_contact.contact_type IN  ('Individual')) AND (civicrm_group.title IN  ('11')) ))

As one can see, the problem lays in civicrm_group.title IN  ('11') which should be civicrm_group.title IN  ('Seniors')

Does somebody know about this problem and how to fix it?

Thanks in advance!

(sorry Pete, I pressed return too early and had not finished my text at that time)
 

should be sorted in the patch we just made

http://issues.civicrm.org/jira/browse/CRM-12009

Actually, not completely. I was doing a view on drupal users, and filtering by civicrm properties. A lot shows up, but no groups and tags.
If I do a view on CiviCRM contacts, I do get options to filter on on group.

I also have option to set contextual filters based on group title; but if I do that, I get the same problem as the original op. The title is taken to be the id field. Entering '9' as a title works, entering 'asia' doesnt. The SQL reads

SELECT civicrm_contact.id AS id
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_group_contact} civicrm_group_contact ON civicrm_contact.id = civicrm_group_contact.contact_id
LEFT JOIN {civicrm_group} civicrm_group ON civicrm_group_contact.group_id = civicrm_group.id
WHERE (( (civicrm_group.id = 'asia') ))
LIMIT 10 OFFSET 0
I guess I can work around it.

$2c,
*-pike