Search error on custom checkbox field

Hey Monish,

Just hit this - assume it's a new 4.7 regression - in which case it would be good to fix in the release on Wed

I created a new custom field against contribution - I chose the type checkbox & wound up have to create a yes option (1) & no (0). When I went to search for the 'no' option I got a DB error & the query was

SELECT count( DISTINCT civicrm_contribution.id ) as rowCount FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id
LEFT JOIN civicrm_value_donation_information_6 ON civicrm_value_donation_information_6.entity_id = `civicrm_contribution`.id WHERE ( civicrm_contribution.is_test = 0 AND civicrm_value_donation_information_6.exclude_from_receipt_list_36 IN '0' ) AND (contact_a.is_deleted = 0)

Note

IN '0'

rather than

IN ('0')