cancel
Showing results for 
Search instead for 
Did you mean: 

Available functions in filter collection

EricLi1
Level 5

May I have advice on what kind of functions are available in filter collection, so far just Len() is workable, others like Upper()/CDbl() /INSTR() are all return Undefined Function error.

e.g.

"Len([Field1])>2" do work.   

"CDbl([Field2])>2" failed.



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

John__Carter
Staff
Staff

Hi Eric the Filter action is essentially an implementation of the .Net DataTable.Select method

https://learn.microsoft.com/en-us/dotnet/api/system.data.datatable.select?view=net-8.0#system-data-datatable-select(system-string)

12340.png



------------------------------
John Carter
Blue Prism
------------------------------

MichealCharron
Level 7

@Eric Li

You can you find the valid functions in the following web page:

     DataColumn.Expression Property (System.Data) | Microsoft Learn

For your CDbl you have to use something like:

"Convert([Field2],'System.Double')>2"

For Instr you have to use something like:

"[Field2] LIKE '*partialstring*'"


------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------
Micheal Charron
RBC
Toronto, Ontario
Canada

Thanks Michael and John, you do help me.

 

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.comwww.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.