Support

  1. 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
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 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.

Request Support

Support is currently Online

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.