topic RE: IN operator in collection filter in Product Forum

IN operator in collection filter

EricLi — Wed, 27 Sep 2023 04:30:00 GMT

How can I use IN operator when filter collection? Such like "fields1 in {'a','b','c'}". Or is it not supported in collection filter?

------------------------------
Eric Li
Operation Analysis
AIG
Asia/Hong_Kong
------------------------------

RE: IN operator in collection filter

TobiasArnold — Wed, 27 Sep 2023 11:27:00 GMT

Hi Eric,

IN is supported. Look here: https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.8

The syntax should be "[field1] IN ('a','b','c')"

Greetings

Tobias

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

RE: IN operator in collection filter

EricLi — Thu, 28 Sep 2023 01:57:00 GMT

Thank you. Tobias!

Eric Li

AIG

Automation Delivery Team | China Service Center

9F, The Centerpoint (Shuion), 374-2 Beijing Road, Guangzhou, China 510030

Tel: (+86 20) 2882 5022

Eric-F.Li@aig.com | www.aig.com

IMPORTANT NOTICE:

The information in this email (and any attachments) is confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify me by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by AIG for any loss or damage arising in any way from its use.