...

...

Function: excluded()

Returns an Array of all items in one Array that are not contained within another Array.

...

excluded(["a","b","c","d","e"],["a", "c","f","d"])

Returns the Array ["b","e"], as do the three expressions below:

listToString(excluded(["a","b","c","d","e"],["a", "c","f","d"]))

listToString(excluded(["a","a","b","c","d","e"],["a", "c","f","d"]))

listToString(excluded(["a","b","c","d","e"],["a","a","c","f","d"]))

Note that if you want to construct conditional expression using excluded() as a predicate, you should use an intermediary countElements() function:

//a list of managers known to us
$validManagersList = ["Rob","Bob"],

//a list that will only have a member if the manager on the output record
//is not found in the list of known managers 
$exclusions = excluded(_out.Manager, $validManagersList),

if(countElements($exclusions) > 0, addElement($errorArray, "The manager on this record was not found in the list of known managers")),

This will add to a list of errors if there is (at least) one member in the list of exclusions.

See Also

• /wiki/spaces/HELPTRUNK/pages/47218905
• Functions