Get queue items based on which are updated today and not created today

[SnehajitDas]

Hello,

I am looking to generate a report from queue items. I am using get queue items function where I see from and to date parameters. These dates are operating on basis of creation date of the queue item and not updated date (start time/end time). Now I want the report to be created for items which are processed today and some status update is made and it is possible that queue item was not added today. Please help if you know best way to handle this requirement.

I can always get all queue items and filter them in code but looking for an optimized way to pull the data from queue.

[Anil_G (Anil Gorthi)]

@SnehajitDas

Use status successful or failed and then using linq query filter based on last processing time

Else you can use orchestrator http request with getaueueitems api and that supports filter on lastprocessingtime as well so can add the same

api reference - <orchestratorurl>/swagger/index.html

Cheers

[AJ_Ask]

Hi @SnehajitDas

By using Get Queue Items also you can achieve it. & Then write that data table to Excel & then filter it as per your need.

HO To get the all the transaction item from the queue

Hi @copy_writes This is how the basic structure will look as there is limitation for get queue items to fetch only 100 we need to add skip with increase in 100 each time [image] also you need to add if condtion to break the loop if the count is 0 in the queue. Add Skip counter with 100 for next set of queue items. In this you can use the for each queue item to create a datatable with all the data. [image] Hope this helps

But I would say Orchestrator HTTP request is better way.

Hope this helps