Help
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 

Filter - Collection

FayazAli
Level 3

‎09-09-19 11:05 AM

Hi All ,

     I have a collection in the below format, and i want to filter the collection where "Actions"="" [empty], how to construct the query for this issue?

Actions Date Descriptions WIID


[collec1.Actions]="" ---> It is not working as expected. Kindly do help me. Thanks.

------------------------------
Fayaz Ali
RPA Developer
Accenture
UTC
------------------------------
0 Likes
2 REPLIES 2

ChenglungTsai1
Level 5

‎09-09-19 11:21 AM

The format is Column= 'Value' .

For example, If you got a collection like below,

ColumnA ColumnB ColumnC
1                  a                b
1                  c                d
2                  a                b
3                  c                d
4                  c                d 

and you want to filter the rows which ColumnB is a.

The filter parameter will be ColumnB ='a' .

If you want to use variables, it will be like [ColumnName]&"='"&[Value]&"'".


​

------------------------------
Chenglung Tsai
Consultant
Avanade
------------------------------
0 Likes

SaumitraSharma
Level 4

‎09-09-19 12:51 PM

It should be [Collection.ColumnName]&"='"& &"'"

------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
Top