Support

  1. msreyes
  2. Presales Question
  3. Thursday, June 04 2020, 02:56 PM
  4.  Subscribe via email
I know with the paid version I can select fields which are drop downs and populate the values. What I will be doing is filling them with locations. I will have about 80 locations :p What I will be doing is getting my members to sign up, and select the correct location.

After that I would like to have an "admin" who can only see users who selected that location.
msreyes Accepted Answer
Pro
That's cool... thanks!!!
  1. more than a month ago
  2. Presales Question
  3. # 1
admin Accepted Answer
Admin
Hi,
If you want to show all users with a same value of logged in user then you can use Custom SQL Where with Content Plugin.

So you can use a syntax like this:
alias = "{user alias raw}"


Our Content Plugin will replace the code {user alias raw} with the value of current logged in user.

Docs:
Custom SQL Where: http://docs.easy-profile.com/index.php/article/sql-custom-where
Content Plugin: http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Presales Question
  3. # 2
msreyes Accepted Answer
Pro
Hmmmm..... seems I broke this.

I have a drop down which users select during login.

I have elevated specific users permissions. If they are part of the same "club" they can see the same members. My menu option for the "Custom SQL WHERE" syntax is alias=alias. But now these users can see everyone, so this filtering isn't working. Anything else I need to turn on to make it work?
  1. more than a month ago
  2. Presales Question
  3. # 3
msreyes Accepted Answer
Pro
Perfect! Works as expected
  1. more than a month ago
  2. Presales Question
  3. # 4
admin Accepted Answer
Admin
Hi,
with location you mean Country and Cities (2 drop downs fields)? if yes then you can fill the dropdown (select) fields with values from DB. Try to see this reply https://www.easy-profile.com/support/conditional-drop-downs.html#reply-11318

After that I would like to have an "admin" who can only see users who selected that location.
There are different ways to make this, you can create a user lists menu item only available for admin (in the menu item you can set "Access" parameter) with a static filter (the parameter is called Custom SQL Where) like
country_field_alias LIKE "_%"
(this is sql to filter only fields with at least 1 char in the value)
  1. more than a month ago
  2. Presales Question
  3. # 5
  • 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.