New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Grid filter for Multiselection field lacks leading/trailing commas in SQL condition #3584

Open
gadget60 opened this Issue Nov 8, 2018 · 0 comments

Comments

Projects
None yet
1 participant
@gadget60

gadget60 commented Nov 8, 2018

Description:

Multiselection field values are stored with leading/trailing/separating comma, but the grid filter won't generate leading/trailing commas for filter values in the SQL WHERE condition.

This leads to broken filters if one Multiselection value happens to be part of another (like having for example two filter values "xxx" and "xxxxxx").

Test case:

Set up a Field of type MultiSelection with values "xxx" and "xxxxxx":
image

The filter won't work for value "xxx" (e.g. won't filter the second row in the example)...
image

...because the generated condition is:
image

instead of:
... ((multiselectLIKE '%,xxx,%')) ...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment