I am trying to create a report using a query from Laserfiche Workflow tables. The report I am aiming to get is one that shows how long a business process took in addition to the specific business process steps duration. The report also needs to have the name of the entry.

My challenge is how to get the name of the entry given that I cannot seem to get the relationship between the first set of tables in relation to the second set of tables.

bp_instance  
workflow_reporting_log  
bp_event  
bp_activity_link  
bp_step  

So far I have managed to get the below sample report.

And

search_entry

search_entry_log

search_instance

Kindly assist.