I have an address field in item.Based on this I am saving latitude and longitude in a table.Now based on location' latitude and longitude can we filter items in search results page.It should show nearest location items first.
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the
FLEXIcontent JED listing
reviews. Thanks![/size]
-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the
FLEXIcontent JED listing
with a 5-star...
My question is how to put our custom query in search ie we are giving an input and getting search results in category.php.
For eg. I am using a location field as filter.So as user selects a location it filters it and displays it in category.php.
Similarly can I filter near by items in that location based on latitude and longitude.Where should I put the custom query for filtering?
the field is multi-property
-- and property array is PHP serialized before storing in DB
--> so you can filter be an SQL query
Our approach for multi-property fields
(for a future FLEXIcontent version)
-- would be to create extra 4 extra DB columns which every field can create up to 4 custom indexes to be used for this purpose
-- Now
1. you can only filter single-property fields, e.g. text field, date field, radio, checkbox, etc fields
2. we support doing this inside FLEXIcontent views and filtering module,
--> please try using FLEXIcontent views and module, if you want to do custom work, then you will need to be up to the challenge, custom code is too much to ask here, remember in some forum you cannot file bug reports for free !! and asking custom code is not done even for paying users
-- i could give you a snipset of code if you describe a small specific problem, that i can understand without having big knowledge of what you want to achieve
(about what you asked above is not easy with an SQL query)
-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the
FLEXIcontent JED listing
with a 5-star...
