Creating SQL Query for Widget
I'm not sure where the right place to post this is but this is all new to me so I thought I'd start here.
We have a custom dashboard for our Logistics dept. They would like us to add a Widget that displays a clickable summary of items assigned to them for the month. I've managed to create a custom Search query that displays all the work items that meets their criteria. How do I convert this to a SQL query that shows a summary of the data with links to details?