Sql query in filter collection

sapna_soni0290 — Thu, 23 Jul 2020 15:49:00 GMT

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

RE: Sql query in filter collection

MayankGoyal2 — Sat, 25 Jul 2020 02:03:00 GMT

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

topic RE: Sql query in filter collection in Product Forum

Sql query in filter collection

RE: Sql query in filter collection