Easy Profile - Joomla Extension

Support

Support is currently Offline

Support Offline

It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!

Official support hours:

Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 10:53 pm

Add a reply View Replies (1)

Resolved Filter by coordinates map module

dladuron
General
Thursday, September 22 2016, 04:12 AM

can you set this filter so that its parameters is determined by the users coordinates and not by fixed lat and long?

Responses (1)

admin Accepted Answer

Admin

Hi,
yes this is possible with SQL Custom Where, SQL Custom Where support also Content Plugin. So for example to filter users with same value of logged in users you can use something like this:



your_field_alias = '{user your_field_alias raw}'

map is composed by 3 fields, so
Map Address: {user your_field_map_alias raw}
Map Lat: {user your_field_map_alias_lat raw}
Map Lng: {user your_field_map_alias_lng raw}

Of course query to make something like this is a bit complex and you need to use in "SQL custom where" some SQL Math functions like RADIANS, COS(cosine), SIN(sine),....

Docs about SQL custom Where: http://docs.easy-profile.com/article/sql-custom-where
Docs about Content Plugin: http://docs.easy-profile.com/index.php/article/content-plugin

more than a month ago
General
# 1

Page :
1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Request Support

Ask a Question

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.