Hi WM Gurus,
I have a simple requirements: Email select SQL results in tabular format. I am not sure how to that. Currently, I use the following steps to generate an xml data that can mapped into STMP body. The problem is the format is xml format, not tabular format.
Thank you for your help!
- run adapter service to get results
- loop the result set and map the result to document list using pub.list:appendToDocumentList
- map the document list to xml string using pub.xml:documentToXMLString
- map the xmldata to email body in pub.client:smtp.
Details are in the attached word document.
WM Email Select Results.docx (75.5 KB)