Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. 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: Thursday 11:27 pm
Add a reply View Replies (0)

Resolved Checkbox value in SQL

  1. NielsHenrik
    NielsHenrik
  2. Support
  3. Tuesday, April 07 2015, 11:29 AM
I am trying to select users based on the checkmarks in a checkbox variable.
The variable is defined as:
Be|Bestyrelsen
KU|Kunstnerisk Udvalg
FU|Festudvalget
By|Byggefonden

I want to enter en expression in the SQL WHERE field which will return all the users with e.g. checkmark in Bestyrelsen, but all I have tried returns an empty result.
Please explain what I should write
Accepted Answer
Fiorino_De_Santo
Fiorino_De_Santo Accepted Answer
Hi,
in database the checkbox or multiselect values are store in JSON format, so you can use something like
alias_field LIKE '%"Be"%'


Json format is something like this:
["FU","Be"]
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (0)


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.