Error with filter

Hi,

We have an error with our filter.

When we only select "Figurant", the users who have "Edelfigurant" in their profile is also shown.

Is this because the word Figurant is also in Edelfigurant?

Any thoughts on how to fix this?

Kind regards.

Filter where? Please be more specific as to what your issue is. I also don't know what "Figurant" or "Edelfigurant" is, sorry.

Hi,

On our user overview page on the front end we have a filter so that producers can find an actor based on what they have filled in on their profile.

Figurant and Edelfigurant are just 2 checkboxes on what kind of actor they are (see screenshot).

But the problem however is that when they select figurant, edelfigurant will show up as well on the result page.

Kind regards.

But the problem however is that when they select figurant, edelfigurant will show up as well on the result page.

edelfigurant contains figurant. That's going to be a problem for searching as in most cases it will use LIKE in the SQL with a wildcard. Especially for multi-checkbox or multi-select fields since they're stored as VALUE_1|*|VALUE_2 in the database. You need to be sure to always use a generic Value that is separate from the Label when configuring your select fields. Example as follows.

Valid Select Options
Value: Opt_1
Label: figurant
Value: Opt_2
Label: edelfigurant

Invalid Select Options
Value: figurant
Value: edelfigurant

The second usage will cause issues. The stored and displayed value are one in the same. Any LIKE based SQL searching will cause the first option to return also the second option because the second option contains the value of the first option. The first usage does not have this problem since the stored values (not seen by the user) are generic, but you can still hit issues with this if not careful (e.g. Opt_1 is within Opt_10). This only impacts fields that allow selecting multiple values (e.g. multi-select or multi-checkbox).

Hi,

Thank you for the response.

It is an already existing website with quite a few users. Is it possible to change this without have to go into every user and tick the "Edelfigurant" checkbox?

I am testing it on a subdomain but when i change the Value of "Edelfigurant" to Opt_1 it is not automatically changed in the user profiles so i have to go into the profile and tick the box again.

Kind regards

Changing the value will not automatically change it for every user. You'd have to manually fix that within your database. Example of how to best do that using SQL.


Replace jos_ with whatever your database prefix is and replace FIELD_NAME with your fields name (e.g. cb_myfield). Be sure to make a backup before doing this. The above will first replace Edelfigurant with Opt_02 then replace Figurant with Opt_01. You can change the Opt_02 and Opt_01 to whatever you like as they're just examples.