Reporting on the BPM Name in which a Task was triggered

[Berto2002]

We have what looks like it could be an out-of-the-box report called, "Tasks - Number Completed Per Person between a specified date range". And in that report I can specified add a column for the BPM instance ID. That's close but actually what I want is to see the BPM name that instance is a version of so that I can quickly find and examine the BPMs that need editing for my purposes.

My question is what table to add to the query and how to link it to be able to return what I call the BPM name.

 

I can add the BPM process table but there's no link in the Request to it's BPM process (and thus the name), only to the BPM instance.

 

[Steve Giller]

The value you're looking for is h_bpm_processes.h_title.

There is no direct link from the Process ID to that, however, so you'd be looking at adding at least two more joins to get the name.

[Berto2002]

I think this may be needed for something we are going to use our Premier Support hours on this year so I'll follow-up there. Thank you.