Incidents without survey repsonses
I'm trying to create a report to show me which incidents within a certain time period did not have a survey submitted. I've tried using the transactions table and trans_type with no luck. trans_type=25 tells me which ones do have a survey, but trans_type not equals 25 gives me all the other transactions.
We use this for random quality monitoring and are currently opening incidents to view at the audit log which is time-consuming.