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.