CiviCRM Community Forums (archive)

I'm trying to create a series of dynamic sildeshows with views.

Each is to display member names and logos belonging a specific membership type, I am using the "CiviCRM Member: Membership Type (= Platinum) " filter, where "platinum" is the membership type.

I have the view built and working, but I cannot figure out how to limit the list only to "primary members".

As I have many contacts attached per primary member I have no way of avoiding a countless number of duplicates in the return, not to mention that only the primary member has an image attached.   

Any ideas?

Hmmm.

I have a smart group with about 300 contacts in it when viewed from "manage groups", of ID 3.

When I add the CiviCRM Contacts: Group(s) (= 3) Filter to the view I get the following:

-------
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.group' in 'where clause'
------

Also, when I simply add the field : CiviCRM Contacts: Group(s) (Group(s))

I get :

-----
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_contact.group' in 'field list'
-----


Oh boy. Does anyone have any clues as to how one may track this down?