Support

    You are here:  
  1. Home
  2. Support
  3. Creating custom fields
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
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.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.