Email note text for all outbound email interactions from Case

CRM 9.0
Tools 8.50

Correspondence management

To find out the email note text for all outbound email interactions from Case:

SELECT A.INTERACTION_ID , D.MSG_TEXT
FROM PS_RI_INTERACTION A , PS_RI_SUB_INTERACT B ,PS_RBC_RECIPIENT C , PS_RBC_RECP_EMAIL D WHERE A.INTERACTION_ID=B.INTERACTION_ID AND C.CMF_ID=D.CMF_ID AND C.INTERACTION_ID=A.INTERACTION_ID AND B.SUBINT_OBJ_TYPE='CASE'
AND A.INTERACTION_MTHD='OEML'
AND B.CASE_ID='1071547'

Outbound emails from case - with case notes

CRM 9.0
Tools 8.50

This is what you may use to find out the email note text for all outbound email interactions from Case:

SELECT A.INTERACTION_ID , D.MSG_TEXT
FROM PS_RI_INTERACTION A , PS_RI_SUB_INTERACT B ,PS_RBC_RECIPIENT C , PS_RBC_RECP_EMAIL D
WHERE A.INTERACTION_ID=B.INTERACTION_ID
AND C.CMF_ID=D.CMF_ID
AND C.INTERACTION_ID=A.INTERACTION_ID
AND B.SUBINT_OBJ_TYPE='CASE'
AND A.INTERACTION_MTHD='OEML'
AND B.CASE_ID='999999'