Convert queueitem enumerable type to list or datatable

Help Activities
, ,
1

Hi everyone,

can anyone please help on the below scenario
I want to check the inputdatatable each row(data) is present in queue or not. But i am having more than 15000 rows in input datatable.

let me know any efficient way to achive this.

Thanks in advance.

2

clear in you requirements if a check can be done with the reference of the queue item as it is known within the input datatable.

If not, then clear in the requirements if a check on the SpecificContent Dictionary is sufficient.

In general we would use the ORC REST API and/or a LINQ for this

3

Hi @ppr,

I can check by using Reference from input datatable in the queue. if there i should not add again.

Linq will be useful.

4

A main Building block could look like this
grafik

ListUpdate = ListDB.Except(ListORC).toList

ListDB = YourDataTable.AsEnumerable.Select(Function (d) d(“ReferenceColNameOrIndex”).toString.Trim).toList

ListORC we can produce by postprocessing an ORC REST API call fetching the reference info only

the new filtered UpdateTable we can achieve by

dtUpdateFiltered =

(From d in dtUpdateOrig.AsEnumerable
Where ListUpdate.Contains(d(ReferenceColNameOrIndex).toString.Trim)
Select r = d).CopyToDataTable

or With a join

(From d in dtUpdateOrig.AsEnumerable
Join x in ListUpdate
On d(ReferenceColNameOrIndex).toString.Trim Equals x
Select r =d).CopyToDataTable
5

Without using api, cant we check whether the item present in the queue or not?

6

have a look on the Get Queue Items Activity