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 3:38 am
Add a reply View Replies (2)

Resolved Custom SQL select not working as expected

  1. arcascomputing
    arcascomputing
  2. General
  3. Tuesday, August 01 2017, 05:24 PM
Trying to filter a user list module by a custom field whose alias is "cluster" and it's a (multiple) Select list but it's not returning any results form when using the following:


cluster = 'Cultural Heritages'

I tested by changing it to:


cluster 'Cultural Heritages'

but still got no results. So i tried filtering by another field (lastname) and this worked okay.
Is my select statement incorrect somehow or is it different for a select list?
  1. custom sql
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
Checkboxes and Select (with multiple values) store data in JSON format.

so for example for values like music, art and sport it store something like ["music","art","sport"], so in your case the best way is to search with something like: 
cluster LIKE "%Cultural Heritages%"


docs about LIKE operator at https://www.w3schools.com/sql/sql_like.asp
  1. more than a month ago
  2. General
  3. # 1
arcascomputing
arcascomputing Accepted Answer
Pro
Understood, thanks.
  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.