Filter collection Action

[AS]

I am always confused in what to write in filter collection action condition field, I mean can we right sql queries in that or we need to follow some specific format, kindly help! 

------------------------------
aanchal mathur
------------------------------

[Neel1]

hello aanchal mathur - there is very good article[mentioned below] on support center which you can read to understand on filter collection.

https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Studio/Visual-Business-Objects/1194312962/What-is-the-syntax-for-an-expression-used-by-the-Filter-Collection-action...

------------------------------
Neeraj Kumar
------------------------------

[harish.m]

Hi Aanchal mathur,

Addition to  the Neeraj recommendation I also recommend to  read the  Microsoft documentation.

https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------