Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IN operator in collection filter

EricLi
Level 6

‎27-09-23 05:30 AM

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
------------------------------
0 Likes
2 REPLIES 2

TobiasArnold
Level 6

‎27-09-23 12:27 PM

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
------------------------------
0 Likes

EricLi
Level 6
In response to TobiasArnold

‎28-09-23 02:57 AM

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.


0 Likes