I followed every step in your tutorial «Filtering Database Query with Multiple Checkboxes» and that works perfectly.
Now my issue is that some records of my database have multiple categories. I separated those category-numbers with commas. So for example if I check the values 2 and 3 the records 1,2 and 4 should show up.
Only the first record shows up when I’m filtering with the checkboxes valued 2 and 3.
I guess I need to adjust the query options but I haven’t found a way it works.
Thank you very much for your help.
I believe the issue here is that your filter is an array with numbers like 2 3 etc while the database holds it as 2 and 2,4. I normally store my categories in a separate database table, not sure if there’s a way to split the categories field from the database directly in the query manager.
You could also try contains but I believe this would then conflict 2 with 20 for example maybe the community have a way this works with your current database structure
Thank you for your response. I tried it with contain but that didn’t work out.
I would prefer to not use a second database if that’s possible.
Maybe someone else will have a solution but thank you anyway!
