Select method using where condition

Help
1

Select Method
Select Method886×316 25.6 KB

Hi From the above image:
dtName.select("Name, Salary where Status=‘Yes’)

Is this query correct?

2

It is showing syntax error in the expression

3

try Filter Datatable activity

4

Is my query correct?

5

@KarthikBallary In assign activity use below query

            dtName= dtName.AsEnumerable.Where(Function(i) i("Status").ToString="yes").CopyToDataTable
6

Ok. In reframework I am not getting get app credential workflow(newly created).

7

dt.Select(“Status=‘yes’”).CopyToDataTable

this is the syntax @KarthikBallary

8

If we need to select particular coulmns, I don’t need ID col

9

you can then use activities to remove those columns!!

10

dtName is of type array of datarows

11

@KarthikBallary dtName is a datatable type.

12

Hi,

I think Filter DataTable Activity will work as @Shivaraju mentioned.

If you want to use expression, the following helps you.

dtNameNew = dtName.AsEnumerable.Where(function(r) r("status").ToString="Yes").CopyToDataTable.DefaultView.ToTable(false,{"Name","Salary"})

Regards,

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.