Filtering Results with CheckBoxes

Ask the community
,
1

Hi,
I have a gallery that is connected to a database. I then have a number of checkboxes that I would like to use to filter the results.
I would like the user to be able to check multiple options and then the filter return based on the selection.

Each record in the database will fall into multiple categories.

At the moment if a user checks just 1 box, the query returns records that fall into just that 1 category. Not the records that fall into that category and other categories.
(hopefully this makes sense)

function FilterAllExtraFilters ( borough , district , type ){
$w ( ‘#DataSetAllVenueListing’ ). setFilter ( wixData . filter ()

. eq ( 'menu' , $w ( '#CheckBoxMenu' ). checked ) 
. eq ( 'welcome' , $w ( '#CheckBoxWelcome' ). checked ) 
. eq ( 'noisy' , $w ( '#CheckBoxNoisy' ). checked ) 
. eq ( 'walks' , $w ( '#Walks' ). checked ) 
. eq ( 'outdoor' , $w ( '#Outdoor' ). checked ) 
. eq ( 'parking' , $w ( '#Parking' ). checked ) 
. eq ( 'stairs' , $w ( '#Stairs' ). checked ) 
). then (( results )=>{

Is it possible to include an If statement? ie only IF the check box is selected add the filter

2

I have just re-read my question, and I’m not sure I explained very well my problem…

My database is a little like this…

771×421 3.56 KB

I then have checkboxes that the user can use to filter the results of a query.

At the moment if the checkbox for Column Filter 1 is checked (and only Column Filter 1) then records 3 and 9 and returned - ie only records where Column Filter 1 is TRUE and the other columns are FALSE
I would like the filter to return records 1,3,4,6 and 9 ie all records where Column Filter 1 is TRUE