Objektová akce

Kód:

6

Tělo:

/* Emails received */  
SELECT 
  DISTINCT 'DE' as DocType, ERA.Parent_ID as Link_ID
FROM
  EmailReceivedAttachments ERA
WHERE
  ERA.Document_ID = :OBJID
UNION ALL
/* Emails Sent */  
SELECT 
  DISTINCT 'OE' as DocType, ESA.Parent_ID as Link_ID
FROM
  EmailSentAttachments ESA
WHERE
  ESA.Document_ID = :OBJID

Generated by ABRA Software a.s. 27.10.2021 16:34:08