I have a process that uses Get Queue Items activity to generate an MI Report which is sent to stakeholders at the end of a business day. The data I want to achieve is very simple
Total Number of Successful Cases
Total Number of Business Exceptions
Total Number of Application Exceptions
The issue with the process at the moment is when totalling the Application Exceptions it will count items in the queue that have been retried. I can see which these are by looking at the Orchestrator Queue under the Revision column.
I believe the solution would be to filter these out (Contains âRetriedâ) - but I cant find how to extract the Revision Column.
The other columns are being extracted like : Item.Status and Item.Reference etcâŚ
Not sure if this will help anyone else, but for whatever reason, filtering out retried queue items using the Get Queue Items activity doesnât work. I tested it isolating it just to retried items when there are definitely Retried Items (manually retried in orchestrator)
To enable me to identify Retried Items, I was able to extract using Item.ReviewStatus.ToString and then filter them out of my Datatable