1. rayjbarrett
  2. General
  3. Tuesday, January 21 2020, 04:34 PM
  4.  Subscribe via email
I have a field type select where the visitor will select a State/Region and it allows for multiple selections. However, when a visitor selects more than one State/Region it expands the criteria to all profiles which have either State/Region. I want it to restrict the results to the profiles which have BOTH/ALL the States/Regions selected. How can I do this?
admin Accepted Answer
unfortunately this is not possible without a hard code change.

In file at /administrator/components/com_jsn/helpers/fields/selectlist.php at line 254 replace this code:
$where.='b.'.$db->quoteName($field->alias).' LIKE '.$db->quote('%"'.$opt.'"%').' OR '.'b.'.$db->quoteName($field->alias).' = '.$db->quote($opt).' OR ';
with this
$where.='(b.'.$db->quoteName($field->alias).' LIKE '.$db->quote('%"'.$opt.'"%').' OR '.'b.'.$db->quoteName($field->alias).' = '.$db->quote($opt).') AND ';
  1. more than a month ago
  2. General
  3. # 1
rayjbarrett Accepted Answer
Worked. Thank you.
  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 Offline

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.