Hi,
I can’t get around this, and have been banging my head around for 24h now. I think I need a hand.
TL;DR :
This always returns 0 matches if the user does not filter by tags. If the user does not filter by tag, I need to display all things. How would you do this?
Detailed version :
I have a list of things. These things have fields like name / phone number … and tags which are links to other things “Tags”
I have 4 filtering fields. Please see the attached image.
A, is a text input field for filtering on “Name OR Firstname OR Phone”
B, is a multiple choide field for filtering on Tags
C, is a multiple choide field for filtering on Status
D, is a text input field for filtering on “City OR Zipcode”
What I want :
- if no filter is set, I want to see all objets in the list
- to see only things where filter_A’s value corresponds to the thing Name or Firstname or Phone number
- the same for filter_D’s … need to match with thing’s city or zipcode
- to see things which have AT LEAST 1 tag in common with the filter_B’s value
- to see things which have AT LEAST 1 status in common with the filter_C’s value
My problem :
I have managed to filter the list correctly using 2 advanced filter for the filter A and D. (but this is heavy for the browser)
However, I can’t manage to work my way around the filter B and C.
My thaught was to use intersect but
This always returns 0 matches if the user does not filter by tags. If the user does not filter by tag, I need to display all things. How would you do this?
How would you do this?
Best to you