Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (2)

Resolved i dont't get the basic filter to work..

  1. kito
    kito
  2. Support
  3. Friday, May 15 2015, 09:12 PM
sorry, i don't get the basics ;-)

try to filter a list (in the sql field box) with this: <erzeuger_hersteller_dienstleister> = '<1>'
alias of field is "<erzeuger_hersteller_dienstleister> = '<1>'"
the field is a checkbox with only value 1.

0 users found, but there are a lot with this value ;-)
what i´m doing wrong?
thx
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
checkbox can have multiple values so the value is not stored in raw mode but in JSON mode.

example for multiples values you have something like this in DB: ["1","7"]

So
to show user who have this value set only to 7 you can insert in SQL Custom Where parameter this: 
field_alias='["7"]'


to show user who have this value that contain 7 (7 and/or another value) you can insert in SQL Custom Where parameter this: 
field_alias LIKE '%"7"%'
  1. more than a month ago
  2. Support
  3. # 1
kito
kito Accepted Answer
Pro
thx! worked.
  1. more than a month ago
  2. Support
  3. # 2
  • 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.