Filter - Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
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
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-09-19 12:51 PM
It should be [Collection.ColumnName]&"='"& &"'"
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
