Hi,
I would like to create specific content related column(s) on transaction level of a queue
because “Reference” is not enough:
I would like to have the reference split into different columns, to be able to make filters when exporting the data to XLS.
Any suggestion where should I search for answer or how to do it?
Thx and kind regards, Vanja
As of now specific content addition or filtering it is not possible directly
For advanced analytics like that use orchestrator api
Cheers
@Anil_G , thx,
can you give me some more information about orchestrator api (links).
Agree with @Anil_G - this functionality doesn’t exist (I have been asking for a while lol).
Alternatively, you can build your own reports downstream to get exactly what you need. Use a Database, Data Fabric or even Insights so create analytics.
Orchestrator api guve a way to extract data via api and you can use as many filters as you need
<orchetartorURL>/swagger/index.html
This has the api and how to call prameters etc you can test it right there..just keep orchestrator open in one tab and then open swagger in another tab and you can authenticate
Cheers
What level orchestrator URL should it be? “View transactions” ?
thx, I found, in my case it is under .local/
I guess with QueueItems_Get I get all transactions of a queue including all additional information (Item Information / View details - Specific Data) for each transaction?
And those I am able to save to XLS file?
yes thats what you should be using
bear in mind it has a limit of 1000 records if you need more then you need to run it in loop it has skip where you can specify number and it would give next set
If you are interested in a local side fix, I have a tampermonkey script that enhances this page.
It doesn’t add any columns (although I think thats possible) because I figure thats abit too dynamic to have been worth writing.
But I have made a script that changes the search box so that searching on Reference works better as it will use ‘Contains’ rather than ‘StartsWith’ for the search, and I made it so you can search for anything within the SpecificContent, so if you know a value of a certain field you can search by that?
oooh, thx, this is very nice offer 
I will write to you in privat.
Yes, I also think 3-5 years ago it was possible to do it somehow with XLS 
Kind regards, Vanja
