The SMF WHERE clause filtering has been further enhanced with new IN/NOTIN comparison operators. These operators allow you to create more concise and efficient SMF field search conditions when compared to searching via numerous conditions connected by multiple AND/OR comparisons.
-
The IN operator returns a TRUE condition if a match is found in the list of values.
"WHERE":"field1 IN ('string_1','string_2',...,'string_n')"-
The NOTIN operator returns a TRUE condition if no match is found in the list of values.
"WHERE":"field1 NOTIN ('string_1','string_2',...,'string_n')" For more information, refer to the “SMF Record Filtering” chapter in the Ironstream Configuration and User’s Guide.