Multiple field filtering?

Ask the community
,
1

I’ve been able to set up multiple field filtering like so:

function filter() {
$w(“#submissions”).setFilter(wixData.filter()
.hasSome(‘format’, formAny)
.and(wixData.filter()
.hasSome(‘genre’, genAny)
.and(wixData.filter()
.hasSome(‘protagonist’, protAny)))
)}
I have formAny etc. set to = the relevant checkboxgroup.value, which works.
But I can’t figure out how to include items where the field is empty, when the input has no value. I can set formAny etc. to = the values of all the checkboxgroup.options (if no options are selected) to include those that match any of the possible options, but I can’t see a way to include empty fields.
If I need to I can potentially have an additional tag to represent ‘none’, but I feel like there’s got to be another way.
Any thoughts?

2 
let filter =  wixData.filter();
if(typeof formAny !== "undefined"){filter = filter.hasSome('format', formAny);}
if(typeof genAny !== "undefined"){filter = filter.hasSome('genre', genAny);}
if(typeof protAny  !== "undefined"){filter = filter.hasSome('protagonist',   protAny);}
 $w("#submissions").setFilter(filter);
3

By the way, I don’t know why you chose to use .hasSome() and not .eq(). You only have 1 value in each, so .eq() makes more sense.

4

@jonatandor35 Thanks so much, it makes a lot of sense and works now!
!== ‘undefined’ didn’t seem to do the trick, but since this showed me how to use if statements in a filter I got it working with .length >0
And I use .hasSome() since they are checkboxgroups with multiple values, perhaps my explanation didn’t make that clear.

5

@rackabello You’re welcome. Whether to use “undefined” or “false” or “null” or an empty string or something else depends on the the values. Maybe in other cases you’ll need the “undefined”.
Your explanation regarding the checkboxGroups is crystal clear now.
:slight_smile: