Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Adding a field to a campaign workflow table using a SQL code activity

AdrianHartNT
Level 1
Level 1

Hello, I'm trying to add some fields to a workflow so that I can use them in an email delivery. The default length for a string field when using an enrichment to add the field is 255 characters. The text I need to put into the string is around 500 characters. To get round this I have used a SQL code activity to add a field:

ALTER TABLE <%= vars.tableName %> ADD senglishIntroText TEXT;

(I believe this creates the field as type HTML which gives 1024 characters)

I then follow this up with some JS code to populate the field.

This seems to work fine, no errors

But...the new field does not appear as part of the targetData schema and is not recognised in the email delivery.

Does anyone know how I can reference/find my new field?

Or, is there another way to increase the length when creating a field using an enrichment?

Thanks,

Adrian.

1 Accepted Solution
AdrianHartNT
Correct answer by
Level 1
Level 1

Found a solution, I added memo fields to recipients, brought into wf and populated with JS. This got round the limitation of only being able to add string fields of length 255 using an enrichment.

View solution in original post

1 Reply
AdrianHartNT
Correct answer by
Level 1
Level 1

Found a solution, I added memo fields to recipients, brought into wf and populated with JS. This got round the limitation of only being able to add string fields of length 255 using an enrichment.

View solution in original post