We use Workflows to generate various "approval" assignments to audit processes. Naturally the Audit team would like to easily access a view to see all the Assignments generated over a period of time per Workflow. However, since the Workflow belongs to the Object and not the assignment, you cannot seem to create a single View that can do this.
What I have is a View with Filter of Object Type = Assignment.
Now unfortunately I need to pull the Workflow from the related Object from the Assignment. But in my case we have multiple types of Objects, not just Documents. So for example, I could set my first Grouping Level to be "Workflow" and the Property used to drive the Grouping is "Document.Workflow". But this then means that only Assignments generated from Workflows on Document Objects get picked up. What I really need is a Wild card operator for the linked object-> [Any Object].Workflow (any property) But this doesn't seem possible. Its more like I want to Union the results of different related object types.Workflow.
I'd rather not resort to simply exporting the data to SQL and making a regular report.
Any ideas?
-Jason
