Support

  1. dladuron
  2. General
  3. 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?
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
  1. more than a month ago
  2. General
  3. # 1
  • Page :
  • 1


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

Request Support

Support is currently Offline

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.