SQL in() operator

[marc]

Here's a suggestion for the calculator: add the in() operator, which works in the same way as in SQL:



Article in(‘TR99’, ‘VEPK’)

Equivalent to

Article == ‘TR99’ || Article == ‘VEPK’

 

[Support]

Here's a suggestion for the calculator: add the in() operator, which works in the same way as in SQL:



Article in(‘TR99’, ‘VEPK’)

Equivalent to

Article == ‘TR99’ || Article == ‘VEPK’

If you have a situation with a complex ‘in’ operation, I suggest you use the ‘FilterOnKey’ box: it's like SQL's ‘IN’ (but ultra-efficient and more ‘visual’): there's an example attached.