Sql query in filter collection

[sapna_soni0290]

Hi all,

Is it possible to enter a SQL query into filter input of filter collection.
Like - select col1,col2 from collection-name

------------------------------
sapna soni
.
Capgemini Pvt Ltd
Asia/Kolkata
------------------------------

[RajathGopal]

No Sapna it is not possible to write a SQL query.

------------------------------
Rajath Gopal
Associate IT Consultant
ITC Infotech
Asia/Kolkata
8904867411
------------------------------

[willem.d4s]

You can use this C# syntax for filtering a collection

https://www.csharp-examples.net/dataview-rowfilter/

with Utility - Collection Manipulation : Filter Collection

------------------------------
Willem Borgesius
Technical Director
Delta4Services
Europe/London
------------------------------

[sapna_soni0290]

Hi Willem,

Sorry i didn't get your point. Are u saying ,selecting particular columns from collection is possible via code. If yes, can you please explain how to achieve that.

------------------------------
sapna soni
.
Capgemini Pvt Ltd
Asia/Kolkata
------------------------------

[Jatin__Kalra · Accepted solution]

Hi @Sapna Soni,

In Filter collection we need to provide collection name and expected Value that you can pass using like : "[First] not like ''"
But selecting particular column from collection we have another action name as Split Collection.​

------------------------------
Jatin Kalra
Assistant Manager
Genpact
Asia/Kolkata
------------------------------