I want to filter a table with a combination of a date range & several discrete parameters. Does the filter string support brackets?
i.e table.filter("date>"&mindate&" AND date <"&maxdate&" AND (p1=true OR p2=true OR p3=true)")
I don't want rows where P1,P2 or P3 are true, but the date is out of the range. If I can't use brackets then I could use some help avoiding selecting what I want PLUS any rows with P2 or P3 being true.
i.e table.filter("date>"&mindate&" AND date <"&maxdate&" AND (p1=true OR p2=true OR p3=true)")
I don't want rows where P1,P2 or P3 are true, but the date is out of the range. If I can't use brackets then I could use some help avoiding selecting what I want PLUS any rows with P2 or P3 being true.
