CiviCRM Community Forums (archive)

I'm seeing the same thing in an upgrade from CiviCRM v3.3 to CiviCRM v3.4.  Where in v3.3 the views filter sql contained the snippet:
WHERE (civicrm_contact.contact_type in ('Organization'))
   AND (civicrm_value_initiatives_4.initiative_15 in ('2'))
   AND ((civicrm_contact.contact_sub_type) = ('Program'))in v3.4 the same snippet looks like:
WHERE (civicrm_contact.contact_type in ('Organization'))
   AND (civicrm_value_initiatives_4.initiative_15 LIKE '%
2
%' )
   AND ((civicrm_contact.contact_sub_type) = ('Program'))This breaks the view.  No fix yet.

I closed the issue and attached a patch for D6/views 2

Hi!  I just upgraded to 3.4.1 and my civicrm view based on member type and member status suddenly stopped working.  I just tested it again by adding someone else to the membership and it is not updating.  Nothing in the view had changed since I created it in 3.4.

Any ideas?  Here's the sql from the view.

SELECT civicrm_contact.id AS id,
   civicrm_contact.organization_name AS civicrm_contact_organization_name,
   civicrm_contact.display_name AS civicrm_contact_display_name,
   civicrm_contact.last_name AS civicrm_contact_last_name,
   civicrm_contact.first_name AS civicrm_contact_first_name
 FROM civicrm_contact civicrm_contact
 LEFT JOIN civicrm_membership civicrm_membership ON civicrm_contact.id = civicrm_membership.contact_id
 WHERE (civicrm_membership.membership_type_id in ('3')) AND (civicrm_membership.status_id in ('1', '2'))
   ORDER BY civicrm_contact_last_name ASC, civicrm_contact_first_name ASC

This view is still not working.  Anyone have any ideas?  Hershel and I are stumped at the moment.

- Annalee

Not quite correct but we will look into it further before posting again.