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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice