I have a summary query with GROUP BY, HAVING, and ORDER BY clauses and I would like to send an email with the results from this query. My workspace can send html results of a query of listing all the records but that is not the summary I’m looking for. The Aggregator transformer doesn’t seem to have what I’m looking for either. Is there a way to send the result of this query shown below? My data is in SQL Server.
SELECT caseID 'ID', count(*) 'Count'
FROM my_table
group by caseID
having count(*) > 1
order by count(*) desc
