I've been asked to create the SQL Statement for a save searched.
It was quite easy until I tried to link to a "custom field". Let me go in more detail.
The search is about location, so the field part is easy
select Name, City... from location
We have unique region. We created a custom fields with all the values
I'm trying to link to the custom field, which I have no idea
Any help will be greatly appreciate