Multiple AND Condition in Select Statement on DataTable

[Rup_1 (Rupesh)]

Hi Friends,
I am able to use select query for single conditions like:-
dt_questionsData.Select(“[ID]=‘6’ AND [Number]=‘161’”).CopyToDataTable
but I want to apply multiple and Conditions with where clause on datatable.

I try like this:-
dt_questionsData.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’ WHERE [Application ID]=‘161’”).CopyToDataTable

then i got error like :- Syntax missing after WHERE operator
Please help me over this.

[AshwinS2 (Ashwin S)]

Hi @Rup_1

Instead of Where you can use and operator

Th@nks

@shwin.S

[Rup_1 (Rupesh)]

@Rup_1

dt_questionsData.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’ WHERE [Application ID]=‘161’”).CopyToDataTable

Hi @ AshwinS2

I tried but i got error like “can not find column [6]”

[Emman_Pelayo]

@Rup_1

dt_questionsData.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’ WHERE [Application ID]=‘161’”).CopyToDataTable

Note that filter inside datatable.select already works as a where clause. Per your scenario, you want to filter Application ID Column first before filtering the ID Column. Basically, you will do two select function to achieve your desired results.

dt_questionsData.Select(“[Application ID]=‘161’”).CopyToDataTable.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’”).CopyToDataTable

[pattyricarte (Patty Boy)]

If you feel no so sure about your codes you can use the filter data table activities @Rup_1

cheers

Happy learning