1. 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?
admin Accepted Answer
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
  1. more than a month ago
  2. General
  3. # 1
arcascomputing Accepted Answer
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.

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.


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.