Lists
Simple Filter
13min
overview the simple filter action allows you to filter simple lists, particularly those comprised of primitive types, used within your process parameters input (required) list to filter ( list\<object> ) filter json configuration (required) configuration for filtering criteria in json format output (required) filtered list ( list\<object> ) filter json configuration the json configuration consists of several parameters { 	"matchtype" "exact", 	"filterexpression" "(regex)expression", 	"fuzzyalgorithm" "levenstein", 	"fuzzythreshold" 0 7, 	"soundexdistance" 4, 	"similarfirstnwords" 1, 	"similarlastnwords" 1, 	"keepiftrue"\ true } matchtype types exact an exact match requires validation ( = ) against the specified filterexpression similar compares against filterexpression considering special characters for example, "john doe" and "john doe" are considered a match after removing special characters phone numbers e g , "376 323 1111" and "323 1111" are considered a match domain/url ignores prefixes like "www" or "http(s) //" email format matches emails with various representations like "@" or "\[at]" fuzzy utilizes algorithms from similarity search to compare fields against filterexpression more details here https //docs procesio com/how to/similarity search contains checks if filterexpression contains the field or vice versa soundex evaluates if two words are similar when spoken, based on a scale from 0 to 4 similarwordmatch compares the first or last n words in the field with those in filterexpression regex validates if the field matches the pattern specified in filterexpression the regex pattern must be json safe/encoded (e g by using test json encode online general php functions functions online https //www functions online com/json encode html ) properties fuzzyalgorithm & fuzzythreshold only used when matchtype = fuzzy if matchtype is something else, those properties will be ignored so, they can be null or can even not be present fuzzyalgorithm needs to be one from this here https //docs procesio com/how to/similarity search , written exactly as in the link provided fuzzythreshold is a double between 0 and 1, where 0 means any match is accepted and 1 requires 100% confidence soundexdistance used only when the matchtype = soundex and it can be set to 0, 1, 2, 3, or 4, where 4 means the words are very similar when spoken similarfirstnwords & similarlastnwords only used when matchtype = similarwordmatch in which case at least one should be >0 if both are =0 then the similarwordmatch will not be executed at all since it does not make sense if matchtype is something else, those properties will be ignored, so, they can have any value or can even not be present keepiftrue determines if the record should be kept based on the match criteria if set to true , the record will be retained important notes matching algorithms operate only on primitive field types, not data structures a row match is true only if all matches are true