Default Filter Operator doesn't seem to work

App Building
,
1

  • Goal: I am attempting to create a multi list filter for my table that will sort via Tags.

  • Steps: I've created three JS queries that gather array data from a GET request tied to a database. The filters come in three keys: Area, Product, Custom. I've created working multiselect filters separated into three boxes depending on the tag type. Because I'm filtering tags which come in as arrays, I have to use intersects when filtering data.

Per box, everything works as expected. My problem happens when selecting an option from box1 and an option from box 2. This creates two individual filters with an AND statement in between.

I could transform everything to strings and use isoneof for my statement to get around this, but that is not ideal. I looked at my default features and saw I could change AND to OR as my default which would fix everything.

Except clicking OR does not affect my filtering in any way. It continues to use AND. This in lies the presumed bug. I've retried the steps, I've rebuilt components, I've tried refreshing and toggling back and forth to see if it would catch the OR statement, but nothing so far.

sample js to pull data
sample js to pull data1071×709 52.5 KB

multi items selected and statemtn
multi items selected and statemtn1565×1023 58.4 KB

or operator is selected while happening
or operator is selected while happening1999×1055 129 KB

1 Like
2

Welp I found a workaround for what I wanted to do.

OR does work if you actually set more than one filter default. So I had to do Timestamp includes (blank) OR Timestamp includes (blank) which forces the OR operator when using the other filtering components.

Also had to update my clear button so that it reset back to the default filter rather than just cleaning everything.