Request Management - report to find the recipient email address

To find the recipient email address.

Some requests are forwarded to others through the mail, this report helps to find the statistics what and how many requests are forwarded to others.

To make any changes to this query, refer to this post.

SELECT wo.workorderid "RequestID",
       wo.title "Subject",
       wor.to_cc_bcc "Parent Request",
       wor.recipient_email "Parent request email ",
       cr.TO_CC_BCC " In conversations",
       cr.recipient_email "Conversation email",
       nr.TO_CC_BCC "Sent mails",
       nr.recipient_email "Sent mail email" FROM workorder wo
LEFT JOIN conversation c ON wo.workorderid=c.workorderid
LEFT JOIN conversationrecipients cr ON c.conversationid=cr.conversationid
LEFT JOIN notify_workorder nw ON nw.workorderid=wo.workorderid
LEFT JOIN notification_recipients nr ON nw.notificationid=nr.notificationid
LEFT JOIN workorder_recipients wor ON wo.workorderid=wor.workorderid
WHERE wo.CREATEDTIME >= <from_lastweek>
  AND wo.CREATEDTIME <= <to_lastweek>
ORDER BY 1