We used workflow to manage creating documents and wanted to be able to create management reports on top of it. I remember having to create some horrible views to allow you to work out where you were in the workflow and what step was next so you could report on it.
It’s just occurred to me that you could have had a parameter on the notifications called something like LAST_NOTIFICATION, which we set to a constant value with the notification name as it passes through. Could also have one with something that does the integration with the stages in the reports we spent all of that time over etc.
I will try it on the prototype I’m building. Should make integration much simpler.
We’ll see …