[SOLVED] Search users by field value

Hello
I have a custom field (named "position") for my users that takes about 20 different values (one for each user). This field is "query dropdown multiple select" and it gets it's options with the following query... The values are populated correctly from the database.

Now i want users to be able to search the userlist by selecting one or more options that are listed in this field.
For example... if user selects option "Technical" in position field to get a userlist with all the users that have "Technical" in their corresponding field.

No way....

I always get a blank search result!

Field settings:
- Searchable
- Selected in List / Parameters / Search

Can you please advise?

Also...
We need the same field to be visible only as a list search field. Not in profile, not in profile edit. So we have placed it in a tab that is in Position "Not displayed on profile 1". Even that the tab is positioned in "Not displayed on profile 1", it shows on profile edit. Can we avoid that somehow?...

Thank you...

How are they supposed to select a value from the field for it to save in the database and for it to then be searched if they can't edit it? Your search is turning up no results because nobody can use the field and thus nobody has a value for that field.

The value can be set for each user either in registration, or by an auto action based on another field value, or by CB Subs. There are ways of setting a value for each user!
What is sure is that there are values stored in the database for the users! In this case the values are stored through an auto action triggered by another field value.

When storing multiple values be sure you're separating them with a |*| delimiter. Example as follows.

VALUE_1|*|VALUE_2

Otherwise they won't store correctly and won't match an option. If they don't match an option they'll be removed from the search during searching. Trying having a user only have 1 option selected then searching for that option. With Joomla debug mode enabled check the debugger at the bottom of the page (or debug bar at bottom of window if J4) and review the userlist query (it will be against _users and _comprofiler) to be sure your field is in the query.

This field does not tale multiple values...

The field is in the query.

It's using AND. So it's trying to match multiple selections exactly. The field appears to be working perfectly fine. If all that criteria doesn't match then it won't find a user. Set your userlist to "simple any" instead of "simple is" or to "advanced" for it to use OR.