What is Hybris Marketing table to find EMail Subject?

[spvamsi]

For our reporting, we need to collect the Email Subjects in Hybris Marketing. What is the Hybris Marketing table that I can refer to collect the Email Subject.

Table- CUAND_ME_ME_ROOT don't have data filled in Subject column.

Table- CUAND_CE_IA_RT has Email Template data filled but not email Subject

[former_member127352 · Accepted solution]

Hello,

You can try table CUAND_ME_BLCK_CT and CUAND_ME_BLOCK. Relation to CUAND_ME_BLCK_CT from CUAND_ME_ME_ROOT is:

CUAND_ME_BLCK_CT-DB_KEY = CUAND_ME_ME_ROOT-ROOT_KEY.

CUAND_ME_BLOCK is a "root" of blocks. Column Email Subject is from older versions.

[former_member127352 · Accepted solution]

sorry - correction: CUAND_ME_ME_ROOT-DB_KEY = CUAND_ME_BLCK_CT-ROOT_KEY

[spvamsi · Accepted solution]

Hi Jiri,

Thanks for immediate response.

Regards,

Vamsi

[spvamsi · Accepted solution]

Hi Jiri,

Thanks for your help.

Need one more favor!

In CUAN_D_INI_ROOT table, i see that the field PERIOD_START and PERIOD_START_TIME are blank for my campaign which is already executed. Is there any specific table and field that I can collect execution start date/time of a campaign. I am currently using in 1709 SP1

Regards,

Vamsi