It would be in the XML memo (data) but of the delivery of the broadLogRcp. Something like this:Hope this helps.If you want to ensure that the variable is used in the HTML content you can check my reply to this question: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-question...

Yes, if you have 4 digits in your field, it will remain the same, if you have 1 digit it will be filled with 3 0s at the left. For more info you have here a list of all database functions and how to use them: https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-d...

Hello, check the function LPad -> To fill with 0s at the left of the number you can use: LPad(@field, 4, '0').With this, you will have 4 digits, with 0s at the left.

Hello, you should use a fork and an enrichment after your data loading file activity, making the enrichment with your table by the column "A", after that put a test that checks if there are some records (vars.recCount > 0):- If there are some records -> Go to End- Else: Recover the data from the dat...

If you need to create a monitoring workflow for deliveries you can query broadlog and tracking log and transform it to see what you need.

Wow that would be so nice! Can you pass me that script?

Hello @RajeshBhat, the content is not stored in the SQL database, so you can't query it BUT you can use the field data with a regular expression. Take a look:The "data" field contains all the XML that forms a delivery. The content is between <content> and </content>, so you can make this query:This ...

Right now, SQL code activities are very useful to clean data from the database or modify temporal tables generated in the workflow.But it would be nice to be able to create temporal tables that can be used in the workflow upstream:Right now, something like this causes an error, but I would like to b...

Hello @_Manoj_Kumar_, this doesn't change the content of the delivery.