Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
livereport that returns email metadata
ftkier
Hello,I need to write a livereport that returns email metadata against items in a folder.The data required to be extracted is the 'from', 'to', 'subject' and 'received date' (similar to that displayed in a Email folder).Can anybody assist?Many thanks
Find more posts tagged with
Comments
Greg_Griffiths_(ggriffiths_-_(deleted))
Fran, The following SQL should do what you want :SELECT * FROM DTree left join OTEmailProperties on OTEmailProperties.NodeID=DTree.DataID where DTree.ParentID=and is taken from :OTEMAIL -> WebNode (Folder) -> WebNode Email Folder -> _GenerateSelect
