Table filter (AND & OR)

Discussion in 'Questions (Windows Mobile)' started by LineCutter, Aug 24, 2007.

  1. LineCutter

    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.
  2. specci48

    specci48 Well-Known Member Licensed User

    Yes, I have already used brackets in my filters...