We need to have a report or dashboard which will tell us how many workflows are there on a portal, number of request against a workflow, recent transaction in a workflow n workflow created on. One can use the below query and get the result need to take in core. SELECT COUNT( a.id ),b.title,MAX(a.created_on) AS recent_transaction,b.created_on AS workflow_created_on FROM #__workflow_transaction AS a LEFT JOIN #__workflow_workflow AS b ON a.form_id= b.id GROUP BY b.id ;