CiviCRM Community Forums (archive)

Hi
I have a civicrm custom field that is a multi checkbox that I need to filter the contact members with.
Details:
Custom field: photography_type - checkbox with values of Wedding|13, Baby|15 etc
Create view selecting Civicrm Contact
  Added the fields needs Contact Name, City, Photography Types.
  Added the filters needs
  Setup Contextual filters - pickup Civicrm Custom Photography Type
  Setup the path to have the % on the end.
Now if a contact member has multiple photograph types checked I can not get any results.
I see these issues.
1. If pass the checkbox field label like Wedding it is not changing it to the key value so not results, the data has the key values store as a list for the contact.
2. If pass the key value of 13 for wedding only getting contacts with only Wedding type not all contacts with multiple photography types checked.
To me it looks like it needs to change the query to use a like

Here is the sql query with Wedding passed as the label.

SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name, civicrm_address.city AS civicrm_address_city, civicrm_address.state_province_id AS civicrm_address_state_province_id, civicrm_value_member_type_1.photography_type_1 AS civicrm_value_member_type_1_photography_type_1, civicrm_value_member_type_1.region_4 AS civicrm_value_member_type_1_region_4
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_membership} civicrm_membership ON civicrm_contact.id = civicrm_membership.contact_id
LEFT JOIN {civicrm_address} civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
LEFT JOIN {civicrm_value_member_type_1} civicrm_value_member_type_1 ON civicrm_contact.id = civicrm_value_member_type_1.entity_id
WHERE (( (civicrm_membership.membership_type_id IN  ('1', '2')) AND (civicrm_membership.status_id IN  ('1', '2', '3')) AND (civicrm_address.location_type_id IN  ('6')) AND (civicrm_value_member_type_1.photography_type_1 = 'Wedding Photographers') ))


Here is the sql with passing key 13 for wedding
SELECT civicrm_contact.id AS id, civicrm_contact.display_name AS civicrm_contact_display_name, civicrm_address.city AS civicrm_address_city, civicrm_address.state_province_id AS civicrm_address_state_province_id, civicrm_value_member_type_1.photography_type_1 AS civicrm_value_member_type_1_photography_type_1, civicrm_value_member_type_1.region_4 AS civicrm_value_member_type_1_region_4
FROM
{civicrm_contact} civicrm_contact
LEFT JOIN {civicrm_membership} civicrm_membership ON civicrm_contact.id = civicrm_membership.contact_id
LEFT JOIN {civicrm_address} civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
LEFT JOIN {civicrm_value_member_type_1} civicrm_value_member_type_1 ON civicrm_contact.id = civicrm_value_member_type_1.entity_id
WHERE (( (civicrm_membership.membership_type_id IN  ('1', '2')) AND (civicrm_membership.status_id IN  ('1', '2', '3')) AND (civicrm_address.location_type_id IN  ('6')) AND (civicrm_value_member_type_1.photography_type_1 = '13') ))

I am using Drupal 7.4, View 3.0-rc1, and Civicrm 4.0.4.

If anyone could help that be greater appreciated. Let me know if you need more information.

Thank you,
Pam