Count Items with specific Reference in queue

Help Activities
, ,
1

Hello,

I need to know how many Items with a specific reference (f.e. “test”) are in my queue.

Currently I use Get Queue Items for every Status New/InProgress/Failed with the Reference I need. That works good, but I don’t know how long do these activities take when it is a big queue (with 1.000 items and more) because I do the same request at least 3 times…

image
image799×231 15.6 KB

image

Therefore I tried to use the Get Queue Items only one time in the first Step to send only one request to the Orchestrator.
In the second Step I want to count the specific items from my queueItem-Variable.

I need an activity which count all items with Status “New” and Reference Test without starting a new request to the orchestrator.

Is there a simple way to do so?

2

Hi @thomas.seeber

In Reference give New within double quotes.

To get the count of transaction items with status New you can use below syntax:

newCount = queue1Items.Count(Function(item) item.Status = QueueItemStatus.New)

queue1Items is the output variable of Get Queue Items Activity and newCount will retrieve count of transaction items with Status New.

Regards

3

when it is about the count we can do it within a single ORC Rest Call along with filtering

4

Thanks a lot. That works :slight_smile:

1 Like
5

You’re welcome @thomas.seeber

Happy Automation!!

6

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