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: Sunday 3:51 am
Add a reply View Replies (3)

Resolved SQL where for a user-list

  1. ws
    ws
  2. Support
  3. Tuesday, March 08 2022, 03:03 PM
Hi, I have two custom fields with select-list,
I want to show a list with users which are not in one of these select-list.
How can I do this?
bereich NOT IN ('Extern') do not function
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
Easy Profile does not do this, anyway there are some workaround, for example with CSS like:
/* For Menu item search */

#jform_bereich_chzn li.active-result[data-option-array-index="2"] {display:none !important;}

/* For Module, replace 123 with the module ID */

#jsearchform123_bereich_chzn li.active-result[data-option-array-index="2"] {display:none !important;}


NOTE: replace 2 with the position of the options, for example if the option is the number 7 then replace with 6 (because the index starts from 0)
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (3)
admin
admin Accepted Answer
Admin
Hi,
if the select allow you to choose multiple values then you should use something like this: 
bereich NOT LIKE '%Extern%'
  1. more than a month ago
  2. Support
  3. # 1
ws
ws Accepted Answer
Pro
I have set
bereich <> '3'
that is function, there the select no multiple values,
but my next problem is to hide this in the search.
  1. more than a month ago
  2. Support
  3. # 2
ws
ws Accepted Answer
Pro
Perfect, that's it.
Now Easy Profile only should be for Joomla 4, this would be mega great.
Thanks for all
  1. more than a month ago
  2. Support
  3. # 3
  • Page :
  • 1


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