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
------------------------------

[MayankGoyal2]

@sapna soni - I believe you can use .net LINQ on it. Collection is .net datatable. Apply filter on it with LINQ and get new datatable as output - 

 ex -

DataTable selectedTable = tb.AsEnumerable()
.Where(r => r.Field<string>("Modul") == value)
.CopyToDataTable();

------------------------------
Mayank Goyal
------------------------------