How to apply Filter Condition with three different Column in Collection?

[MohiniShelke]

Hello All,

I have two use filter condition for three different column in Collection using BluePrism filter collection ?

How to acheive  this?


Thanks
Mohini

------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------

[hossein.azimi]

Hi Mohini,

For example:

We have three text data item called:
FilterVar that contains a string for the "Name".
FilterVarID that contains a string for the "ID".
FilterVarAdress that contains a string for the "Address".

ID	Name	Address
6	John	US
5	David	UK
2	Alex	AU
6	Ben	JP
7	Bob	UK
4	John	US
1	David	US
8	Matthew	AU
9	Kelly	UK

Please try the logic as:  ("[Name] = '"&[FilterVar]&"' OR [ID] = '"&[FilterVar]&"' OR [Address] = '"&[FilterVarAdd]&"'") etc.

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Australia/Sydney
------------------------------