topic RE: Available functions in filter collection in Product Forum

Available functions in filter collection

EricLi — Thu, 11 Jan 2024 09:07:00 GMT

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

RE: Available functions in filter collection

John__Carter — Thu, 11 Jan 2024 15:10:00 GMT

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)

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

RE: Available functions in filter collection

MichealCharron — Thu, 11 Jan 2024 15:31:00 GMT

@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
------------------------------

RE: Available functions in filter collection

EricLi — Fri, 12 Jan 2024 03:37:00 GMT

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