Table/Schema for delivery content | Community
Skip to main content
tejashriw155148
Level 4
Oct 22, 2019 1:45 PM UTC
Solved

Table/Schema for delivery content

Hi,

Please let me know the text content which sent to customer through SMS/Email delivery are stored in which table or schema?

Regards,

Tejashri Waje

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
somasundaram_h
somasundaram_hAccepted solution
New Participant
Oct 24, 2019 7:51 AM UTC

Hi there,

Hope the below answers your question.

Thanks.

13 replies

tejashriw155148
Level 4
Oct 23, 2019 6:15 AM UTC

HI Sourav,

I checked XML memo(data) field but it is blank. No content inside the field.

Regards,

Tejashri

Translate
asktam1410
Level 3
Oct 22, 2019 5:14 PM UTC

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.

Translate
Sourav_Sadhu
Level 2
Oct 22, 2019 2:13 PM UTC

Hi,

You can find the content in the nms:delivery table, the attribute name is XML memo (data) -- Sql field is mdata.

Thanks,

Sourav

Translate