1 Reply Latest reply on Nov 2, 2016 9:23 AM by Shawn Wallwork

    Multiple and & or contains

    wout.degreef

      I am getting closer and closer to the right solution. But the next problem i have is with the following contains script:

       

      CONTAINS([C1],STR( [Parameter 1] )) OR

      CONTAINS([C2],STR( [Parameter 1] )) OR

      CONTAINS([C3],STR( [Parameter 1] )) OR

      CONTAINS([C4],STR( [Parameter 1] )) OR

      CONTAINS([C5],STR( [Parameter 1] )) OR

      CONTAINS([C6],STR( [Parameter 1] )) OR

      CONTAINS([C7],STR( [Parameter 1] )) OR

      CONTAINS([C8],STR( [Parameter 1] )) OR

      CONTAINS([C9],STR( [Parameter 1] )) OR

      CONTAINS([C10],STR( [Parameter 1] ))

      AND

      CONTAINS([C1],STR( [Parameter 2] )) OR

      CONTAINS([C2],STR( [Parameter 2] )) OR

      CONTAINS([C3],STR( [Parameter 2] )) OR

      CONTAINS([C4],STR( [Parameter 2] )) OR

      CONTAINS([C5],STR( [Parameter 2] )) OR

      CONTAINS([C6],STR( [Parameter 2] )) OR

      CONTAINS([C7],STR( [Parameter 2] )) OR

      CONTAINS([C8],STR( [Parameter 2] )) OR

      CONTAINS([C9],STR( [Parameter 2] )) OR

      CONTAINS([C10],STR( [Parameter 2] ))

       

      Their is already a match when 1 of the 2 parameters corresponds with the datastrings of C1-C2-C3....-C10. But i only want a match when both parameters corresponds with the datastring.

       

      Please help me