I have items in Orchestrator queues with one of the specificContent is in date format, say the name is ‘beginDate’. I marked this specificContent as the reference when I export this to ORCH using activity ‘Add Queue Item’. Now what I want is: taking the items and process is based on the earliest date of the queue. How can I arrange best?
I was thinking if I can make use the filter property of Get Transaction Item?
you could get them all as text, put in a list, convert them all to real DateTime and then choose the one you want to process, maybe need to go back to a new getqueueitem, this time retrieve only the one to process.
this Item can now be used for fetching it with get Transaction Item and with the Reference ID we adress just the earliest one with FirstQueueItem.Reference
It is recommended to incorporate some exception handling e.g empty Queue and there will not be an earliest TI. But in general it worked.
Thank you for this precious help.
I will try to implement it today and see if it works.
Will update the answer soon
UPDATE:
I tried to sort the datatable ascending before exporting it to ORCH and it performs the queues ascendingly. anyway thank you very much for your input guys! keep the forum alive