Drupal views with filter for group title - wrong SQL

[damaxl]

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)
 

[petednz]

you need to provide more details

[petednz]

should be sorted in the patch we just made

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

[commonpike]

I'm using drupal 7.31 and civi 4.4.6, but the groups arent showing up in the views interface at all ? CiviCRM is there, with members, address, custom fields, relationships, events, but I see no tags and no groups.

I do see the relevant code in civicrm.core.inc. Is there something I need to enable ?

strange,
*-pike

[commonpike]

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

Code: [Select]

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