Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.8
-
Fix Version/s: 4.7.2
-
Component/s: CiviCRM Search
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
This issue is related to CRM-16922, CRM-16938 and the other "smart groups break on upgrade to 4.6" tickets, but seems to be a distinct bug. It's caused because of a difference in how form_value stores certain fields in 4.6 vs. earlier versions.
At the bottom of this ticket, I've pasted the result of SELECT * FROM civicrm_saved_search WHERE id = 25. This saved search has just one criterium; find records whose address's location_type_id = 6.
The relevant part is this. In 4.4.6, civicrm_saved_search.form_values stores the array for location_type like this:
{{ [location_type] => Array
(
[0] => 6
)
}}
However, Civi 4.6.8 stores the array like this:
{{ [location_type] => Array
(
[6] => 1
)
}}
However, on upgrade, the saved_search doesn't get updated, so the search breaks - in this case, it searches on "location_type_id = 1".
{{
From Civi 4.4.6:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | form_values | mapping_id | search_custom_id | where_clause | select_tables | where_tables |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 25 | a:112:{s:5:"qfKey";s:37:"fe93d3e36853260be4c708001e2d8fe6_8258";s:8:"entryURL";s:48:"https://cpehn.org/civicrm/contact/search?reset=1";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:2:"OR";s:14:"privacy_toggle";s:1:"1";s:13:"email_on_hold";a:1:
{s:7:"on_hold";s:0:"";}
s:30:"preferred_communication_method";a:5: {i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;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:6:"county";a:0:{}s:14:"state_province";a:0:{}s:7:"country";s:0:"";s:12:"address_name";s:0:"";s:13:"prox_distance";s:0:"";s:18:"prox_distance_unit";s:5:"miles";s:12:"world_region";s:0:"";s:13:"location_type";a:1: {i:6;s:1:"1";}s:13:"hidden_custom";s:1:"1";s:17:"Academia/Research";s:0:"";s:8:"Advocacy";s:0:"";s:11:"Association";s:0:"";s:35:"Community-Based Organization/Clinic";s:0:"";s:10:"Consultant";s:0:"";s:11:"Corporation";s:0:"";s:29:"Ethnic Physician Organization";s:0:"";s:18:"Federal Government";s:0:"";s:10:"Foundation";s:0:"";s:11:"Health Plan";s:0:"";s:8:"Hospital";s:0:"";s:16:"Local Government";s:0:"";s:5:"Media";s:0:"";s:5:"Other";s:0:"";s:14:"Other Provider";s:0:"";s:16:"State Government";s:0:"";s:17:"Tribal Government";s:0:"";s:5:"Union";s:0:"";s:6:"Vendor";s:0:"";s:13:"CiviCRM_OP_OR";s:0:"";s:8:"custom_1";a:20: {s:17:"Academia/Research";s:0:"";s:8:"Advocacy";s:0:"";s:11:"Association";s:0:"";s:35:"Community-Based Organization/Clinic";s:0:"";s:10:"Consultant";s:0:"";s:11:"Corporation";s:0:"";s:29:"Ethnic Physician Organization";s:0:"";s:18:"Federal Government";s:0:"";s:10:"Foundation";s:0:"";s:11:"Health Plan";s:0:"";s:8:"Hospital";s:0:"";s:16:"Local Government";s:0:"";s:5:"Media";s:0:"";s:5:"Other";s:0:"";s:14:"Other Provider";s:0:"";s:16:"State Government";s:0:"";s:17:"Tribal Government";s:0:"";s:5:"Union";s:0:"";s:6:"Vendor";s:0:"";s:13:"CiviCRM_OP_OR";s:0:"";}s:16:"African American";s:0:"";s:5:"Asian";s:0:"";s:26:"Asian and Pacific Islander";s:0:"";s:6:"Latino";s:0:"";s:15:"Native American";s:0:"";s:16:"Pacific Islander";s:0:"";s:8:"custom_2";a:8: {s:16:"African American";s:0:"";s:5:"Asian";s:0:"";s:26:"Asian and Pacific Islander";s:0:"";s:6:"Latino";s:0:"";s:15:"Native American";s:0:"";s:16:"Pacific Islander";s:0:"";s:5:"Other";s:0:"";s:13:"CiviCRM_OP_OR";s:0:"";}s:8:"custom_3";s:0:"";s:8:"custom_5";s:0:"";s:8:"custom_7";s:0:"";s:8:"custom_8";s:0:"";s:14:"custom_14_from";s:0:"";s:12:"custom_14_to";s:0:"";s:14:"custom_15_from";s:0:"";s:12:"custom_15_to";s:0:"";s:14:"custom_16_from";s:0:"";s:12:"custom_16_to";s:0:"";s:14:"custom_18_from";s:0:"";s:12:"custom_18_to";s:0:"";s:14:"custom_20_from";s:0:"";s:12:"custom_20_to";s:0:"";s:14:"custom_17_from";s:0:"";s:12:"custom_17_to";s:0:"";s:14:"custom_19_from";s:0:"";s:12:"custom_19_to";s:0:"";s:14:"custom_21_from";s:0:"";s:12:"custom_21_to";s:0:"";s:14:"custom_22_from";s:0:"";s:12:"custom_22_to";s:0:"";s:14:"custom_23_from";s:0:"";s:12:"custom_23_to";s:0:"";s:14:"custom_24_from";s:0:"";s:12:"custom_24_to";s:0:"";s:14:"custom_25_from";s:0:"";s:12:"custom_25_to";s:0:"";s:14:"custom_26_from";s:0:"";s:12:"custom_26_to";s:0:"";s:14:"custom_42_from";s:0:"";s:12:"custom_42_to";s:0:"";s:14:"custom_27_from";s:0:"";s:12:"custom_27_to";s:0:"";s:14:"custom_43_from";s:0:"";s:12:"custom_43_to";s:0:"";s:14:"custom_28_from";s:0:"";s:12:"custom_28_to";s:0:"";s:4:"task";s:2:"13";s:8:"radio_ts";s:6:"ts_all";} |
NULL | NULL | ( civicrm_address.location_type_id IN (6) ) | 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:21:"civicrm_location_type";i:1;s:19:"civicrm_worldregion";i:1;}
|
a:2:
{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;}
|
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
After upgrade to Civi 4.6.8:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | form_values | mapping_id | search_custom_id | where_clause | select_tables | where_tables |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 25 | a:114:{s:5:"qfKey";s:37:"fe93d3e36853260be4c708001e2d8fe6_8258";s:8:"entryURL";s:48:"https://cpehn.org/civicrm/contact/search?reset=1";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:2:"OR";s:14:"privacy_toggle";s:1:"1";s:13:"email_on_hold";a:1:
{s:7:"on_hold";s:0:"";}
s:30:"preferred_communication_method";a:5: {i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;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:6:"county";a:0:{}s:14:"state_province";a:0:{}s:7:"country";s:0:"";s:12:"address_name";s:0:"";s:13:"prox_distance";s:0:"";s:18:"prox_distance_unit";s:5:"miles";s:12:"world_region";s:0:"";s:13:"location_type";a:1: {i:6;s:1:"1";}s:13:"hidden_custom";s:1:"1";s:17:"Academia/Research";s:0:"";s:8:"Advocacy";s:0:"";s:11:"Association";s:0:"";s:35:"Community-Based Organization/Clinic";s:0:"";s:10:"Consultant";s:0:"";s:11:"Corporation";s:0:"";s:29:"Ethnic Physician Organization";s:0:"";s:18:"Federal Government";s:0:"";s:10:"Foundation";s:0:"";s:11:"Health Plan";s:0:"";s:8:"Hospital";s:0:"";s:16:"Local Government";s:0:"";s:5:"Media";s:0:"";s:5:"Other";s:0:"";s:14:"Other Provider";s:0:"";s:16:"State Government";s:0:"";s:17:"Tribal Government";s:0:"";s:5:"Union";s:0:"";s:6:"Vendor";s:0:"";s:13:"CiviCRM_OP_OR";s:0:"";s:8:"custom_1";a:0:{}s:16:"African American";s:0:"";s:5:"Asian";s:0:"";s:26:"Asian and Pacific Islander";s:0:"";s:6:"Latino";s:0:"";s:15:"Native American";s:0:"";s:16:"Pacific Islander";s:0:"";s:8:"custom_2";a:0:{}s:8:"custom_3";s:0:"";s:8:"custom_5";s:0:"";s:8:"custom_7";s:0:"";s:8:"custom_8";s:0:"";s:14:"custom_14_from";s:0:"";s:12:"custom_14_to";s:0:"";s:14:"custom_15_from";s:0:"";s:12:"custom_15_to";s:0:"";s:14:"custom_16_from";s:0:"";s:12:"custom_16_to";s:0:"";s:14:"custom_18_from";s:0:"";s:12:"custom_18_to";s:0:"";s:14:"custom_20_from";s:0:"";s:12:"custom_20_to";s:0:"";s:14:"custom_17_from";s:0:"";s:12:"custom_17_to";s:0:"";s:14:"custom_19_from";s:0:"";s:12:"custom_19_to";s:0:"";s:14:"custom_21_from";s:0:"";s:12:"custom_21_to";s:0:"";s:14:"custom_22_from";s:0:"";s:12:"custom_22_to";s:0:"";s:14:"custom_23_from";s:0:"";s:12:"custom_23_to";s:0:"";s:14:"custom_24_from";s:0:"";s:12:"custom_24_to";s:0:"";s:14:"custom_25_from";s:0:"";s:12:"custom_25_to";s:0:"";s:14:"custom_26_from";s:0:"";s:12:"custom_26_to";s:0:"";s:14:"custom_42_from";s:0:"";s:12:"custom_42_to";s:0:"";s:14:"custom_27_from";s:0:"";s:12:"custom_27_to";s:0:"";s:14:"custom_43_from";s:0:"";s:12:"custom_43_to";s:0:"";s:14:"custom_28_from";s:0:"";s:12:"custom_28_to";s:0:"";s:4:"task";s:2:"13";s:8:"radio_ts";s:6:"ts_all";s:17:"custom_1_operator";s:3:"and";s:17:"custom_2_operator";s:3:"and";} |
NULL | NULL | ( civicrm_address.location_type_id IN (6) ) | 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:21:"civicrm_location_type";i:1;s:19:"civicrm_worldregion";i:1;}
|
a:2:
{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;}
|
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Civi 4.6.8 after resaving the smart group:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | form_values | mapping_id | search_custom_id | where_clause | select_tables | where_tables |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 25 | a:92:{s:5:"qfKey";s:37:"7a4b408df8d6c4ed3760a57149a09277_1735";s:8:"entryURL";s:48:"https://cpehn.org/civicrm/contact/search?reset=1";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:1:"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:2:"OR";s:14:"privacy_toggle";s:1:"1";s:13:"email_on_hold";a:1:
{s:7:"on_hold";s:0:"";}
s:30:"preferred_communication_method";a:5: {i:1;s:0:"";i:2;s:0:"";i:3;s:0:"";i:4;s:0:"";i:5;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:7:"country";s:0:"";s:14:"state_province";a:0:{}s:6:"county";a:0:{}s:12:"address_name";s:0:"";s:13:"prox_distance";s:0:"";s:18:"prox_distance_unit";s:5:"miles";s:12:"world_region";s:0:"";s:13:"location_type";a:1: {i:0;s:1:"6";}s:13:"hidden_custom";s:1:"1";s:8:"custom_1";a:0:{}s:17:"custom_1_operator";s:0:"";s:8:"custom_2";a:0:{}s:17:"custom_2_operator";s:0:"";s:8:"custom_3";s:0:"";s:8:"custom_5";a:0:{}s:8:"custom_7";a:0:{}s:9:"custom_48";a:0:{}s:8:"custom_8";s:0:"";s:14:"custom_14_from";s:0:"";s:12:"custom_14_to";s:0:"";s:14:"custom_15_from";s:0:"";s:12:"custom_15_to";s:0:"";s:14:"custom_16_from";s:0:"";s:12:"custom_16_to";s:0:"";s:14:"custom_18_from";s:0:"";s:12:"custom_18_to";s:0:"";s:14:"custom_20_from";s:0:"";s:12:"custom_20_to";s:0:"";s:14:"custom_17_from";s:0:"";s:12:"custom_17_to";s:0:"";s:14:"custom_19_from";s:0:"";s:12:"custom_19_to";s:0:"";s:14:"custom_21_from";s:0:"";s:12:"custom_21_to";s:0:"";s:14:"custom_22_from";s:0:"";s:12:"custom_22_to";s:0:"";s:14:"custom_23_from";s:0:"";s:12:"custom_23_to";s:0:"";s:14:"custom_24_from";s:0:"";s:12:"custom_24_to";s:0:"";s:14:"custom_25_from";s:0:"";s:12:"custom_25_to";s:0:"";s:14:"custom_26_from";s:0:"";s:12:"custom_26_to";s:0:"";s:14:"custom_42_from";s:0:"";s:12:"custom_42_to";s:0:"";s:14:"custom_27_from";s:0:"";s:12:"custom_27_to";s:0:"";s:14:"custom_43_from";s:0:"";s:12:"custom_43_to";s:0:"";s:14:"custom_28_from";s:0:"";s:12:"custom_28_to";s:0:"";s:9:"custom_32";a:0:{}s:9:"custom_46";a:0:{}s:18:"custom_46_operator";s:0:"";s:4:"task";s:2:"14";s:8:"radio_ts";s:6:"ts_all";} |
NULL | NULL | ( civicrm_address.location_type_id IN (6) ) | 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:21:"civicrm_location_type";i:1;s:19:"civicrm_worldregion";i:1;}
|
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:21:"civicrm_location_type";i:1;s:19:"civicrm_worldregion";i:1;}
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------}}
Attachments
Issue Links
- is supplemented by
-
-
- Reopened
-
- links to