topic RE: Filter - Collection in Product Forum https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91441#M41460 It should be&nbsp;<STRONG>[Collection.ColumnName]&amp;"='"&amp; &amp;"'"</STRONG><BR /><BR />------------------------------<BR />Saumitra Sharma<BR />Consultant<BR />EY<BR />Indian/Christmas<BR />------------------------------<BR /> Mon, 09 Sep 2019 11:51:00 GMT SaumitraSharma 2019-09-09T11:51:00Z Filter - Collection https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91439#M41458 Hi All ,<BR /><BR />&nbsp; &nbsp; &nbsp;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?<BR /><BR />Actions Date Descriptions WIID<BR /><BR /><BR />[collec1.Actions]="" ---&gt; It is not working as expected. Kindly do help me. Thanks.<BR /><BR />------------------------------<BR />Fayaz Ali<BR />RPA Developer<BR />Accenture<BR />UTC<BR />------------------------------<BR /> Mon, 09 Sep 2019 10:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91439#M41458 FayazAli 2019-09-09T10:05:00Z RE: Filter - Collection https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91440#M41459 The format is <STRONG>Column= 'Value' .<BR /><BR /></STRONG>For example, If you got a collection like below,<BR /><BR />ColumnA ColumnB&nbsp;ColumnC<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b<BR />1&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b<BR />3&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d<BR />4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d&nbsp;<BR /><BR />and you want to filter the rows which&nbsp;ColumnB is a.<BR /><BR />The filter parameter will be&nbsp;<STRONG>ColumnB ='a'</STRONG> .<BR /><BR />If you want to use variables, it will be like <STRONG>[ColumnName]&amp;"='"&amp;[Value]&amp;"'"</STRONG>.<BR /><BR /><BR />​<BR /><BR />------------------------------<BR />Chenglung Tsai<BR />Consultant<BR />Avanade<BR />------------------------------<BR /> Mon, 09 Sep 2019 10:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91440#M41459 ChenglungTsai1 2019-09-09T10:21:00Z RE: Filter - Collection https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91441#M41460 It should be&nbsp;<STRONG>[Collection.ColumnName]&amp;"='"&amp; &amp;"'"</STRONG><BR /><BR />------------------------------<BR />Saumitra Sharma<BR />Consultant<BR />EY<BR />Indian/Christmas<BR />------------------------------<BR /> Mon, 09 Sep 2019 11:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Filter-Collection/m-p/91441#M41460 SaumitraSharma 2019-09-09T11:51:00Z