Not Getting Desied Output from Query

Help Studio
1

HI,

EMPDT.Select(“[Department]='IT’or [Department]=‘Finance’ AND [Salary]<20000”).CopyToDataTable

I use the above query but I am getting output that is not correct. Where is my Mistake will someone please help me

Message Box

Name,Date of Joining,Department,Salary

Raghunath,6/7/1952,Finance,8000

Navnit,15/2/1971,IT,20000

Mahadeo,27/11/1920,IT,32000

Parth,28/01/2010,IT,35000

OK

2

Hi,

Can you try the following expression?

EMPDT.Select("([Department]='IT'or [Department]='Finance') AND [Salary]<20000").CopyToDataTable

Regards,

3

Hey Yoichi

Thanks Your query is working and issue resolved

Thanks

1 Like
4

EMTP.Select(“[Department]='IT’ or [Department]=‘Finance’ )AND ([Salary]<20000”).CopyToDataTable