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 4:21 am
Add a reply View Replies (4)

Resolved Problem to set a static filters on Users Lists

  1. gadocane
    gadocane
  2. Features Request
  3. Thursday, September 22 2016, 04:12 PM
Good morning, I have a problem to set a static filters on Users Lists. I try to filter Users with custom fields, so I create a field named "tipologia" (checkbox type) and 2 values named "artista" and "locale". I try to filter the users that check the value "locale" in the field "tipologia" with the SQL Custom Where parameter:

tipologia LIKE '%"locale"%'

but it dosn't work, and the list doesn't return to me any results.
Can you help me?
Thank you!!!
  1. user list
Responses (4)
admin
admin Accepted Answer
Admin
Hi,
can you provide me your site details to check this? you can use the form below the reply in "Site Details" tab (it is private)
  1. more than a month ago
  2. Features Request
  3. # 1
gadocane
gadocane Accepted Answer
Ok
  1. more than a month ago
  2. Features Request
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
thanks.

I found the problem, you have these options:
0|Artista
1|Locale

values stored in DB are 0 and 1, so the correct SQL Custom Where parameter is


tipologia LIKE '%"1"%'
  1. more than a month ago
  2. Features Request
  3. # 3
gadocane
gadocane Accepted Answer
Thank you very much!!!
  1. more than a month ago
  2. Features Request
  3. # 4
  • Page :
  • 1


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