Reverse Filter - Multiple Filters/Overlapping Filters

Ask the community
,
6

@salman-hammed Thanks. This is working great except I have one dropdown that I want to connect to a few fields that are booleans.

Any thoughts or help on how to fit this code (or rather the result of ):

let filterPrice = $w("#priceRange").value;
 if (filterPrice === "500") {
                                         $w("#dataset1").setFilter(wixData.filter().eq("upTo500", true));
                                }
 if (filterPrice === "1000") {
                                         $w("#dataset1").setFilter(wixData.filter().eq("to1000", true));
                                }
 if (filterPrice === "1001") {
                                          $w("#dataset1").setFilter(wixData.filter().eq("over1000", true));
                                }

On to this line of your code (so my multiple filters work together) where color would be filterPrice:

if (color && color !== 'all') {	
	filter = filter.eq("color", color);	
}

Any guidance would be GREATLY appreciated. I’ve been at this for weeks with no result. The struggle is that I don’t want to use a greater than or less than, but rather search a specific price range. I have the value in a number column as well, the boolean was a hack to try and accomplish searching a specific range.