Table filter (AND & OR)

LineCutter

Active Member
Licensed User
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.
 
Top