Expand my Community achievements bar.

SOLVED

Table/Schema for delivery content

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Level 5

Hi there,

Hope the below answers your question.

1846384_pastedImage_1.png

Thanks.

View solution in original post

13 Replies

Avatar

Level 3

Hi,

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

1846382_pastedImage_0.png

1846383_pastedImage_1.png

Thanks,

Sourav

Avatar

Level 4

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.

Avatar

Level 4

HI Sourav,

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

Regards,

Tejashri

Avatar

Community Advisor

Hi,

You can check delivery text content using below xml format in Javascript:

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 ;

Thanks.

Avatar

Level 4

Thanks Jyoti for the info.

I'm not familiar with java script code, so could you please let me now how to use above xml format in javascript?

Regards,

Tejashri

Avatar

Correct answer by
Level 5

Hi there,

Hope the below answers your question.

1846384_pastedImage_1.png

Thanks.

Avatar

Level 4

HI,

How to parse expression delivery/content/sms/@source in javascript?

When added highlighted expression in javacript code

SMS_javasciptCode.PNG

getting below error:

SMS_Javascript_Error.PNG

Regards,

Tejashri

Avatar

Level 4

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:

DeliverySourceError.PNG

How can retrieve source data.

Regards,

Tejashri

Avatar

Level 4

!

Hi,

somasundaramhaldurai

How to define alias in below format?

alias.PNG

Thanks,

Tejashri

Avatar

Level 4

how to extract delivery/content/sms/source field from nms:broadLogRcp table?

I tried below code but the content not coming.

deliverySource.PNG

Thanks,

Tejashri