Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
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 7:40 pm
Add a reply View Replies (8)

Resolved SQL Custom WHERE selectlist

  1. vinnie
    vinnie
  2. General
  3. Sunday, May 27 2018, 10:26 PM
Good morning,
I am trying to make the map module to show only some users; I just can't make it with fileds under a "selectlist".

This
NOTE: fields like checkbox or select (with multiple value enabled) store the data in DB with JSON format, so something like this ["music","art","design"], so to filter users you need to use SQL LIKE command, example to have users interested to music: interests LIKE '%"music"%'
found on the documentation didn't help much.

Let's say, I have a field whose alias is "areas_of_expertise" and the user I want to select has the expertise "test": how should the query look like?

thanks.
Responses (8)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, it was a weekend for us.

Your select field allow multiple values? if yes then the SQL Where should be something like 
areas_of_expertise LIKE '%"test"%'
  1. more than a month ago
  2. General
  3. # 1
vinnie
vinnie Accepted Answer
no problem, it's not late at all!

Well, that's what it's said in the documentation but it does not work.
The map doesn't load, as you can see in the screenshot.

thanks.
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Can you please post me a screenshot of your select field configuration?
- Main Page (where I can see the name and the alias of field)
- Options (where I can see the list of options)
  1. more than a month ago
  2. General
  3. # 3
vinnie
vinnie Accepted Answer
Sure!
thanks!
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
Thanks, you should use value and not the text so SQL Where become: 
areas_of_expertise LIKE '%"8"%'
  1. more than a month ago
  2. General
  3. # 5
vinnie
vinnie Accepted Answer
thanks a lot, I'd suggest to add it on the documentation.

One last thing: the map shows the selected user, but it zoom it too much; can it be like showing the map with less zoom?
In the attachment you can see how the map looks like now.
Thanks!
  1. more than a month ago
  2. General
  3. # 6
vinnie
vinnie Accepted Answer
I'm sorry, I forgot to enclose the attachment (no way to edit own post?)
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply,

Normally the maps should show all users, so the zoom was set automatically. When you have 1 user then the default zoom is 17 (valid values are from 1 to 20)

You can change this default value with a template override, please follow these steps:
- Copy file from /mod_jsnmap/tmpl/default.php to /templates/your-template-folder/html/mod_jsnmap/default.php (or default_somethingelse.php**)
- Open new file and replace "17" with your new value at line 148
  1. more than a month ago
  2. General
  3. # 8
  • Page :
  • 1


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