Search kit - address issues
A user tried to configure a search & I have pasted the export of it below the screenshot. She hit 2 issues - one is just a 'The UI is hard` thing and the other is a probable bug
The UI issue is that she chose the Country
from the primary_address
pseudo rather than the Contact Address
table in the join
The probably bug is that Primary Address.Country
can be added to the select fields - but not Primary Address.street_address
- she realised she had a mix - which is when she contacted me
[
[
"SavedSearch",
"save",
{
"records": [
{
"name": "test_search",
"label": "Test Search",
"form_values": null,
"mapping_id": null,
"search_custom_id": null,
"api_entity": "Contact",
"api_params": {
"version": 4,
"select": [
"id",
"display_name",
"first_name",
"last_name",
"GROUP_CONCAT(DISTINCT Contact_Address_contact_id_01.street_address) AS GROUP_CONCAT_Contact_Address_contact_id_01_street_address",
"address_primary.city",
"address_primary.state_province_id:label",
"GROUP_CONCAT(DISTINCT Contact_Address_contact_id_01.postal_code) AS GROUP_CONCAT_Contact_Address_contact_id_01_postal_code",
"address_primary.country_id:label"
],
"orderBy": [],
"where": [
[
"contact_type:name",
"=",
"Individual"
]
],
"groupBy": [
"id"
],
"join": [
[
"Address AS Contact_Address_contact_id_01",
"INNER",
[
"id",
"=",
"Contact_Address_contact_id_01.contact_id"
],
[
"Contact_Address_contact_id_01.street_address",
"IS NOT EMPTY"
],
[
"address_primary.country_id",
"IN",
[
"1228",
"1039"
]
]
],
[
"Contribution AS Contact_Contribution_contact_id_01",
"INNER",
[
"id",
"=",
"Contact_Contribution_contact_id_01.contact_id"
],
[
"Contact_Contribution_contact_id_01.total_amount",
"BETWEEN",
[
"250.00",
"499.99"
]
],
[
"Contact_Contribution_contact_id_01.receive_date",
">=",
"\"2018-07-01\""
]
]
],
"having": []
},
"expires_date": null,
"description": null
}
],
"match": [
"name"
]
}
]
]