5 Replies Latest reply on Mar 13, 2010 6:16 PM by Steve Wright

    Find function driving be bonkers

    LeoB

      Title

      Find function driving be bonkers

      Post

      I'm trying to insert a find function in a script, but no matter what it won't work.

       

      The table has two pertinent fields and the find is a combination of both: Risk and Status.

       

      I want to find all High Risk records that are NOT Closed.

       

      I tried:

       

      Issue::Risk: [=High] AND Issue::Status: [=Open]

       

      Then:

       

      Find Records   Issue::Risk: [=High]

      Omit Records  Issue::Status: [=Closed]

       

       

      And a whole bunch of other permutations, and nothing returns correct results.

       

      Why is "Specify Find Requests" so counterintuitive?

       

      Thanks.