3 Replies Latest reply on Mar 17, 2015 12:59 PM by disabled_collegechurch

    Scripting constraining found set with multiple = and ≠ requests?

      Title

      Scripting constraining found set with multiple = and ≠ requests?

      Post

      I have a database, of which a percentage are members, and I want to script membership lists of those who live in New England and those who do not. The first part was easy.

      To script finding the NE members I created a new script, called a script that finds all current members and sorts them by name, then constrained the found set:

      Perform Script ["Sort Membership List"]
      Constrain Found Set [Restore]
      

      In the Constrain step I have

      Action: Find Records        Criteria: State: [=MA], [=CT], [=RI], etc. 

      This works fine for finding everyone who is a member and lives in New England, but when I change the = to ≠ and run the script it says "No records match these find criteria." Is there a way to do this?