Workflow Table Field size > 255 | Community
Skip to main content
D
dipendu_g
Level 5
June 4, 2024
Solved

Workflow Table Field size > 255

  • June 4, 2024
  • 3 replies
  • 3710 views

Hi Team,

 

I am using a query in a workflow that group records and concats field. The result of this concat field sometimes extend beyond 255, which triggers an error in the Query workflow activity, is there a way to accommodate characters > 255, in a temporary worktable.

 

The idea is to use that conca field later in the workflow activity to do further processing

 

 

I tried using the Edit Schema, but not sure how to go about it ?

 

Please suggest some alternatives

 

Regards,

DG

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by AkshayAnand

Hi @dipendu_g 

 

You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.

loadLibrary

Use Javascript libraries in Adobe Campaign

 

Regards

Akshay

3 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
June 5, 2024

Hello @dipendu_g 

 

You can use the XML Memo field from Recipient schema in an Enrichment and change the alias according toy our requirement and use this field. This newly created field will inherit the length of the XML Memo field which is 2000 characters.

 

 

 

Manoj     Find me on LinkedIn
D
dipendu_gAuthor
Level 5
June 5, 2024

Hi @_manoj_kumar_ ,

 

Thanks for your reply, I am using a user defined SQL Function(xtk:funclist), that creates a string > 255 characters. I am still getting the String truncate error.

 

 

 

Regards,

DG 

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
June 5, 2024

@dipendu_g  Can you share a screenshot of this setup?

Manoj     Find me on LinkedIn
AkshayAnand
Community Advisor
AkshayAnandCommunity Advisor
Community Advisor
June 5, 2024

Hi @dipendu_g 

 

You can use the JavaScript to concatenate the string as Below:-

var result = ''; var name = new Array("A1", "A2", "A3"); for (var i=0; i<name.length; i++){ fName = name[i]; logInfo ("fName "+name[i]); result = result.concat(fName, ","); logInfo ("Result "+result); }

 

Regards

Akshay

    D
    dipendu_gAuthor
    Level 5
    June 5, 2024

    Hi @akshayanand, @_manoj_kumar_,

     

    The requirement is to create a new SQL function so that can be easily used by the Campaign Managers, like other SQL functions

     

    Is 255 Characters max in case of temporary table created in workflow, or can they be extended to hold larger value 

     

    Regards,

    DG

    AkshayAnand
    Community Advisor
    AkshayAnandCommunity AdvisorAccepted solution
    Community Advisor
    June 6, 2024

    Hi @dipendu_g 

     

    You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.

    loadLibrary

    Use Javascript libraries in Adobe Campaign

     

    Regards

    Akshay

      CampaignerForLife
      CampaignerForLife
      Level 5
      June 5, 2024

      Try adding a new SQL Activity with this code:

      ALTER TABLE <%= vars.tableName %> ADD LongString NCLOB;

      and then insert in that LongString the concat 

      D
      dipendu_gAuthor
      Level 5
      June 5, 2024

      There is no change, I mean no column is added after the transition. I used Varchar instead of NCLOB.

       

      Can somebody please post the setup, if possible

       

      Regards,

      DG

      Terms & ConditionsAccessibility statement

      Loading footer...