1 Reply Latest reply on Jun 17, 2016 4:13 AM by AdrianHartNT

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

    AdrianHartNT 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.