Please explain why using 3 lines would cause a problem.  You can "AND" or "OR" the 3 clauses to ensure that "Fruit" contains all 3 or any of the 3.

I have more than 3 lines. Around 20 lines. So i wanted to check do we have any possibility to avoid 20 lines

I think you are saying you want the equivalent of select * from table where fruit in (Apple, Orange, Banana). I do not believe that is supported. If you have 100 fruits but only 20 define your exception, then write your rule with 1 row per fruit resulting in about 20 rows. If you are targeting the 80 fruits instead of the 20, then still write the rules in terms of the 20 with the appropriate adjustments to the boolean operators etc.

Sorry if I am hijacking the thread but it may be relevant: if you have multiple lines in your condition and have both "AND" and "OR" clauses in it, does the whole condition need to begin and end with a parentheses?

Hi Brian. I think the answer is No. For example, the following two scenarios would not require additional parenthesis before the first line and after the last - it would only require the parenthesis shown.

Option 1:

Row 1

AND Row 2

Option 2:

Row 1

AND ( Row 2

OR Row 3)