Please let me know the text content which sent to customer through SMS/Email delivery are stored in which table or schema?
Hope the below answers your question.
You can find the content in the nms:delivery table, the attribute name is XML memo (data) -- Sql field is mdata.
Try similar to this.
Yes, this is answer to my question.
how to extract delivery/content/sms/source field from nms:broadLogRcp table?
I tried below code but the content not coming.
How to define alias in below format?
Tried above code but its not giving value of source.
Hence changed code to <node expr="[content/sms/@source"] alias="@content"/> and its throwing below error:
How can retrieve source data.
You may try the below:
When added highlighted expression in javacript code
getting below error:
Thanks Jyoti for the info.
var emailText= delivery.content.text.source.toString();
var emailHTML= delivery.content.html.source.toString();
It will give you XML structure of your email. You can fetch whatever data you want to fetch, like you want to get URL of your HTML you can use:
var url= delivery.content.text.urlConfig.url ;
I checked XML memo(data) field but it is blank. No content inside the field.
Anything related to the delivery will be stored in nms:delivery schema. If you used AEM content then you need to write QueryDef to read actual content Id that was synchronized with the delivery and then find it in AEM.