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: Saturday 7:25 pm
Add a reply View Replies (2)

Resolved Custom SQL not working for checkbox

  1. francis-saa-dittoh
    francis-saa-dittoh
  2. General
  3. Thursday, March 22 2018, 03:49 PM
Hi, I have a checkbox with option list (I have tried numbers as well)

accra_office|Accra Office
directorate_of_procurement|Directorate of Procurement
estates_directorate|Estates Directorate
finance_directorate|Finance Directorate
ict_directorate|ICT Directorate

My User List module is not listing anything with office = "ict_directorate"

Other fields work normally with the same module

Please advise
  1. checkbox
  2. custom sql
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
checkbox field type store data into JSON format, so to have a correct Custom SQL Where it should be something like: 
office LIKE '%"ict_directorate"%'


docs at http://docs.easy-profile.com/index.php/article/sql-custom-where
  1. more than a month ago
  2. General
  3. # 1
francis-saa-dittoh
francis-saa-dittoh Accepted Answer
Thanks a lot. I missed that in the article
  1. more than a month ago
  2. General
  3. # 2
  • Page :
  • 1


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