Query To See Process Data Folders That Have View Data Deleted?

benji

Is there a query I can use that will allow me to see which process data folders exist on the front end but have had their process view data deleted? I want to track all of these records down.

kairo_Decisions

This query will do just that:

SELECT *

FROM folder_state

JOIN flow_tracking_folder_data

ON folder_state.entity_folder_id = flow_tracking_folder_data.entity_id

WHERE folder_state.deleted = 1;