Error when trying to return query result

I’m using this query to select data from datatable lwr

lwr.Select("[STATUS UGOVORA/PARTIJE] =‘1 - aktivan’ ").CopyToDataTable

but getting not just ‘1 - aktivan’, but other values like ‘2 - zatvoren’ or ‘3 - otpis’

Could anyone help me with this issue?

Hi @dvojinovic

Use filter datatable and pass the value…try it and see that should solve.

Cheers

2 Likes

it fails.
Is there any other solution?

Hi @dvojinovic

Show me screenshots of what you did…did you give a output datatable?

Cheers

But again, it shows me other values “2 - zatvoren” “3 - otpis”

image

Hi @dvojinovic

Can you share the sample input excel file?

Regards
Gokul