We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Compare against multiple values

Comments

2 comments

  • Avatar
    Adrian Williams

    Hi Bart,

    There is an existing enhancement request for this functionality.

    Ref. LAE-10848

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Hi Bart,

    the above Jira reference is for the other enhancement request you raised - appologies for any confusion caused.

    The existing functionality of the Filter node and Split node enables you to define multiple filter criteria, e.g.

    Selecting a field in the 'Select field' drop-down list will create a new criterion. By default the criteria are joined using the 'Match all of the following' operator - which provides a logical AND of the criteria. You can click on the 'Match all of the following' button to display the other methods for joining the criteria:

    The 'Match any' operator provides a logical OR of the critera and the 'Match none' operator implements the inverse of this, i.e. NOT( <criteria A> OR <criteria B>).

    A single critera group is present on the node by default but you can click on the 'Add new criteria group' button to insert another criteria group into the grid:

    The default operation to join the criteria in each group is to 'Satisfy all groups' i.e. an AND function. You can click on the 'Satisfy all groups' button to change this to 'Satisfy any group' i.e. an OR function.

    For example in the following configuration, the two criteria in the top filter group are ANDed together. Similarly, the two criteria in the lower filter group are ANDed together. The filter groups combined using an OR operator.

    The Split node also supports the equivalent functionality. Please see the node Help documentation for details. 

    If required you can customize the filter criteria with your own scripting by selecting the 'Advanced' tab.

    As noted in the UI, if you modify the criteri script that was automatically generated by the grid selections this will clear the grid. We recommended that when investigating a custom script, you make a copy of the node and modify the script in that node until you are happy with it's operation - this means you still have access to the original filter as a fall-back. 

    Regards,

    Adrian

    0
    Comment actions Permalink

Please sign in to leave a comment.