AnsweredAssumed Answered

Scripting constraining found set with multiple = and ≠ requests?

Question asked by disabled_collegechurch on Mar 17, 2015
Latest reply on Mar 17, 2015 by disabled_collegechurch

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?

Outcomes