Support

    You are here:  
  1. Home
  2. Support
  3. Error - COM_JSN_N_ITEMS_FAILED_PUBLISHING after adding new group and fields
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. 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: Monday 12:26 am
Add a reply View Replies (5)

Resolved Limiting list module display pages

  1. dladuron
    dladuron
  2. Support
  3. Tuesday, November 10 2015, 05:05 AM
I want to be able to limit the display of the list that is generated by the list module to specific profile pages.

I want it to be displayed on user profiles using a specific user id (i.e. user id12)
I do NOT want the list to be displayed on user profiles using a specific user id (i.e. user id 8)

Any idea on how I can do this?
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
maybe I have not understand your question, anyway I try to reply

You can use SQL custom where to filter users, in SQL custom where you can use also our content plugin.

for example with this SQL custom where the module show all users except current user displayed on current profile page
id != {user id displayed raw}


Docs about SQL Custom Where at http://docs.easy-profile.com/article/sql-custom-where
Docs about Content Plugin at http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Support
  3. # 1
dladuron
dladuron Accepted Answer
no - sql only limits who is on the list.

I want the list to be displayed with all users of particular id's.
I want the list to be displayed to all users except on specific users profiles.

Example: SQL 'group_id IN (12,8)' greats List of users A, B, C

User profile A (group id 12) page - displays list with users A, B, C

User profile B (group id 12) page - displays list with users A, B, C

User profile C (group id 8) page - does not display list
  1. more than a month ago
  2. Support
  3. # 2
admin
admin Accepted Answer
Admin
This is possible, but is complex.

Sql custom where put the value into DB query, and mysql support IF statement, so for example:

( IF( {user avatar displayed raw} IN (406,407), 1, 0) = 1 AND group_id IN (12,8) ) OR ( IF( {user avatar displayed raw} IN (408,409), 1, 0) = 1 AND group_id IN (12) ) OR ( IF( {user avatar displayed raw} IN (410,411), 1, 0) = 1 AND group_id IN (8) )


in this example:
- if you see profile page of user 406 and 407 you will see a list of users from group 12 and 8
- if you see profile page of user 408 and 409 you will see a list of users from group 12
- if you see profile page of user 410 and 411 you will see a list of users from group 8

{user avatar displayed raw} this code return id of current displayed user
  1. more than a month ago
  2. Support
  3. # 3
dladuron
dladuron Accepted Answer
Getting closer but still missing the mark.
I want a list of all users to be displayed on every users profile page EXCEPT those users profile that belong to group id (12)

Display if {user avatar displayed raw} groupid != 12
  1. more than a month ago
  2. Support
  3. # 4
admin
admin Accepted Answer
Admin
Sorry this is too complex for our support, build this query require too time.

we can point you on right way, but can't do this for you.

you need to add a sql SELECT into IF statement...it's possible but very complex.
  1. more than a month ago
  2. Support
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Offline
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.