Question on searching on custom fields

As many do, we have custom fields set up for our members. When searching on these fields, any field that can have multiple values never returns search results.

I can search on other custom fields that only have a single value, but ones that can have multiple don't seem to work.

Is there any trick to this before I write custom code to do this?

I'll assume by the silence that there's no way to do this. What a shame.

Time whip up a bunch of LIKEs

I'm on the search users page in CP Admin.

I have a couple custom fields that are multi-valued. By default, the "additional fields" are added to the default search functionality. Selecting any of those radio buttons for fields that can have multiple values results in no values returned. Searching on custom fields that aren't multi-valued return the expected results.

Is users_find_by_string the only method available to query with? Or is there a more generic one available? users_find_by_string doesn't seem like it'd support a series of OR clauses.

Surely someone has had the need to do this before.

Hello,

What version of aMember are you using? I was able to modify the function users_find_by_string() located in mysql.inc.php in version 3.1.0 of aMember to fix the problem you are experiencing.

I created a custom field "mypets" and set multiple select values of "cat, dog, gorilla" and was able to find users that matched a single select value. In other words the search string had to be for either "cat", "dog", or "gorilla". You could not combine them. If you wanted a more complicated search string that matched multiple values to a user such as "cat OR dog" or "dog AND gorilla" then that would be more complicated and would require more work.

Jimmy

We're still on 3.0.8.

The only thing I have in my mysql.inc.php file is includes to the ionCube/Zend loaders.

I tried looking for that function definition, but obviously it's all obfuscated in the ioncube stuff.

Hmm...looking at 3.1.1, seems they've extracted some of those functions back into mysql.inc.php. Looks like i'm upgrading sooner rather than later

Is this fixed yet?

I downloaded aMember Pro 3.1.4TRIAL but I can not search on custom fields with multiple values. This is a real problem for me/us.

It would be even better if it is possible to search for "cat OR dog" or "dog AND gorilla" (as in the example of jimjwright)

When searching on custom fields, any field that can have multiple values never returns search results.

Is there a solution for this problem?

3 Years and no solution???

I hate to wake up an old thread, but in 3 years there has never been a solution to this??? I have searched the amember forum to find what I needed, and this is the only thread discussing this question.

My problem is related in that I built a custom member search plugin based on users.php from the admin section. Works great after customizing, etc., but members cannot search any custom fields that contain multiple values (in this case, designations).

Can anyone provide an answer to this three years later? Thank you!!!