topic RE: Sql query in filter collection in Product Forum

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

RajathGopal — Fri, 24 Jul 2020 04:34:00 GMT

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

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

RE: Sql query in filter collection

willem.borg — Fri, 24 Jul 2020 08:14:00 GMT

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

RE: Sql query in filter collection

sapna_soni0290 — Fri, 24 Jul 2020 08:57:00 GMT

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

RE: Sql query in filter collection

Jatin__Kalra — Sat, 25 Jul 2020 11:24:00 GMT

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