tests/phpunit/CRM/Contact/BAO/SavedSearchDataSets/251_empty_email_on_hold.sql

   1 INSERT INTO `civicrm_saved_search` (`id`, `form_values`, `mapping_id`, `search_custom_id`, `where_clause`, `select_tables`, `where_tables`) VALUES (77, 'a:58:{s:5:"qfKey";s:37:"27e1084e725e5a1d4335639ceb45e4bc_3852";s:12:"hidden_basic";s:1:"1";s:12:"contact_type";a:0:{}s:5:"group";a:0:{}s:10:"group_type";a:0:{}s:21:"group_search_selected";s:5:"group";s:12:"contact_tags";a:0:{}s:9:"sort_name";s:0:"";s:5:"email";s:0:"";s:14:"contact_source";s:0:"";s:9:"job_title";s:0:"";s:10:"contact_id";s:0:"";s:19:"external_identifier";s:0:"";s:7:"uf_user";s:0:"";s:10:"tag_search";s:0:"";s:11:"uf_group_id";s:0:"";s:14:"component_mode";s:1:"1";s:8:"operator";s:3:"AND";s:25:"display_relationship_type";s:0:"";s:15:"privacy_options";a:0:{}s:16:"privacy_operator";s:3:"AND";s:14:"privacy_toggle";s:1:"1";s:13:"email_on_hold";a:1:{s:7:"on_hold";N;}s:30:"preferred_communication_method";a:6:{i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;s:0:"";i:6;s:0:"";}s:18:"preferred_language";s:0:"";s:13:"phone_numeric";s:0:"";s:22:"phone_location_type_id";s:0:"";s:19:"phone_phone_type_id";s:0:"";s:15:"hidden_location";s:1:"1";s:14:"street_address";s:0:"";s:15:"postal_code_low";s:0:"";s:16:"postal_code_high";s:0:"";s:4:"city";s:0:"";s:11:"postal_code";s:0:"";s:14:"state_province";a:1:{i:0;s:4:"1641";}s:7:"country";s:0:"";s:13:"prox_distance";s:0:"";s:18:"prox_distance_unit";s:5:"miles";s:12:"world_region";s:0:"";s:21:"hidden_CiviContribute";s:1:"1";s:19:"contribution_source";s:0:"";s:21:"contribution_date_low";s:0:"";s:22:"contribution_date_high";s:0:"";s:23:"contribution_amount_low";s:0:"";s:24:"contribution_amount_high";s:0:"";s:22:"contribution_status_id";a:0:{}s:38:"contribution_thankyou_date_is_not_null";s:0:"";s:37:"contribution_receipt_date_is_not_null";s:0:"";s:24:"contribution_in_honor_of";s:0:"";s:22:"contribution_pay_later";s:0:"";s:22:"contribution_recurring";s:0:"";s:17:"contribution_test";s:0:"";s:27:"contribution_transaction_id";s:0:"";s:25:"contribution_check_number";s:0:"";s:32:"contribution_pcp_display_in_roll";s:0:"";s:24:"contribution_campaign_id";a:0:{}s:4:"task";s:2:"14";s:8:"radio_ts";s:6:"ts_all";}', NULL, NULL, ' ( civicrm_address.state_province_id IN (1641) ) ', 'a:7:{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;s:15:"civicrm_country";i:1;s:13:"civicrm_email";i:1;s:13:"civicrm_phone";i:1;s:10:"civicrm_im";i:1;s:19:"civicrm_worldregion";i:1;}', 'a:2:{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;}');
   2
   3 INSERT INTO `civicrm_group` (`id`, `name`, `title`, `description`, `source`, `saved_search_id`, `is_active`, `visibility`, `where_clause`, `select_tables`, `where_tables`, `group_type`, `cache_date`, `refresh_date`, `parents`, `children`, `is_hidden`, `is_reserved`, `created_id`) VALUES (251, 'Qld_All', 'Qld All', 'All contacts with Qld as the State', NULL, 77, 1, 'User and User Admin Only', ' ( `civicrm_group_contact_cache_251`.group_id = 251 ) ', 'a:8:{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;s:15:"civicrm_country";i:1;s:13:"civicrm_email";i:1;s:13:"civicrm_phone";i:1;s:10:"civicrm_im";i:1;s:19:"civicrm_worldregion";i:1;s:33:"`civicrm_group_contact_cache_251`";s:136:" LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_251` ON contact_a.id = `civicrm_group_contact_cache_251`.contact_id ";}', 'a:2:{s:15:"civicrm_contact";i:1;s:33:"`civicrm_group_contact_cache_251`";s:136:" LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_251` ON contact_a.id = `civicrm_group_contact_cache_251`.contact_id ";}', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);