I would like to know if there is a way to get like a report of all the scheduled workflows and if it is possible to know at what time as well. I tried to use the "Workflows in waiting state" schema but I realize that workflows that uses an "external signal" are also coming and I dont want them on the report.
It is working fine, thank you! and one more thing the value @nextProcessingDate doesnt say if the workflow runs daily,weekly,etc. I wanted to have the information of the schedule activity for instance : Triggering at 2:00:00 AM, Daily ... is there any way to do that ?
That's available in [activities/schedule/period], though would take parsing. Best practice is to label schedule activities after their period, e.g. 'Every day at 9 PM', which would be [activities/schedule/@label]. These refer to the first schedule activity in the workflow fwiw.
I have similar type of requirement very recently. Two attribute can help you. Go to xtk:workflow and apply filter on column Status (@state) = 'Started' and in output you can have workflow internal name, label and Next processing (@nextProcessingDate) to check the desired result. Please note you will get the workflow name where you are running this query as well, because this workflow will be in started, hence you can exclude this wf.
