FILTER WORK ITEMS TABLE

Help
, , ,
1

Hello guys, Im tryng to write on a excel file the result of the work item with this filter:
row(“Description”).Equals(“Calculate Client Security Hash”) AND row(“Status”).Equals(“Open”) AND CINT(row(“WIID”))<600000

but I dont get why this is the result :frowning: exam

2

Hi , Pls try using select Method
Use Assign activity
Datatable = Datatable.select(“[Description] = ‘Calculate Client Security Hash’ AND [Status] = ‘Open’ AND [WIID]<600000”).copytodatatable

3

where should I place the assign activity?

4

Hi , after you scrap/ get the details of the workitems into the Datatable

5

1
11099×543 36.8 KB
2
2813×404 13.7 KB
3
3813×386 12.6 KB
4
4817×423 14.4 KB

this is what it looks like… didnt try ur method yet

6

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