[#6231] User Search function issue

Hello Team,

I have a user list where displays all of my trainers.
"an exaple of their specialities for the multi select check box field " -->
Value | Label
0 --> Personal Trainer
1 --> Yoga
.. ---> ....
10 -->MMA

User 'A' is Personal Trainer (0) and Yoga(1)
User 'B' is MMA (10)

I noticed that (at Front End) When Searching for Personal Trainers (0) it also Displays the user 'B' where it should not.

Then I edited user 'B' to be without MMA(10) and the Search is working fine like this.

It seems to me that is working with 'Like' insead of 'In'

You can try it here (I added MMA again) --> www.personaltrain.gr/index.php/personal/grigori-anazitisi
*If you check to search only for personal trainers you will see 3 of them but only 2 should be there. The woman is not.

How can I overcome this?

Thank you.

It'll use LIKE for a multi-select fieldtypes search usage since they're stored value_1|*|value_2|*|value_3. So if 1 value contains the the value of another you'll get results like this. I really don't recommend using integer values for options but instead something more specific. At any rate have added a feature ticket to see if I can improve this further.

forge.joomlapolis.com/issues/6231

Hello,

It is as I thought.
So what do you suggest to set the value to.
Letters is fine?
I mean If I give something more specific I will avoid this?

Thank you

Use unique values that won't be within another value. Example as follows.

trainer = Personal Trainer
yoga = Yoga
mma = MMA

Ok I see,

So
yoga --> Yoga (its okay)
yo --> Yoga1 (it wont work well)
ayo --> Air Yoga (its okay)

That is the concept ?
I can work with that if so.

Thank you.

Correct, as long as one value doesn't contain the value of another you should have no problems.