I have a set of data that has multiple columns and when using the following in my structure:
filters:[
{name:"CrewMemberName", type:"text"},
{name:"ReportStatus", type:"multiselect"},
{name:"PickupCity", type:"text"},
{name:"CallType", type:"multiselect"},
{name:"Outcome", type:"multiselect"},
{name:"Vehicle", type:"multiselect"},
{name:"Dispatch_Weekday", type:"multiselect"},
],
It simply does nothing when the Crew Member name is entered. If I eliminate any of the other filters, it does work. It’s almost like the filters are using an OR instead of an AND when there are multiple filters available.
How do I set the filtering to work with an AND condition, instead of OR?