memo description is not working

[Haricharan]

Hi Guys,

I have created a field element called memo description using the type memo to hold large amount of value, while calling the filed using targetdata . memodescription inside the delivery to print the value stored in memo description, the value is not populating.

But i tried calling someother filed using target data , that field value is populating correctly.

[isahore]

Hi @Haricharan,

Is the memo field holding data in the actual data table or are you populating it in the temp table while the workflow is executing?

I tried adding memo type field to my recipient table, and put values into it, both string and xml. The preview displayed without issues.

If you can share your code, may be the community can help better.

BR,

Ishan

[Haricharan]

Hi Ishan,

I'm populating the data's in the temp table while the workflow is executing?

and I could not able to populate the data's using memo filed?

Let me know your concerns.

[isahore]

@Haricharan,

Is your memo field holding string values, xml or html?

Are you able to print the values of the memo variable using logInfo() ?

BR,

Ishan

[Haricharan]

Hi Ishan,

Memo filed holding html values.

Instead of memo i just used string value to populate the table in delivery its working fine and but only thing is string can hold upto 255 character.

and i can able to print the values in loginfo using memo field.

[isahore]

@Haricharan,

In that case, you need to also change the data source back to FFDA after writing to your temp schema and before sending the delivery. I hope this will resolve your issue.

P.S. I have not tried and tested this yet.

BR,

Ishan

[Haricharan]

Hi Ishan,

I have attached the screenshot for the change data source, kindly confirm and let me know.

[isahore]

@Haricharan,

this should work if you have only ffda external account.

BR,

Ishan

[Haricharan]

I dont have FFDA external account, do you any other suggession to overcome this issue

[isahore]

@Haricharan go ahead with the screenshot setting you shared in the previous comment. Let me know if that worked.

BR,

Ishan

[Haricharan]

It is also not working!

But instead of memo field type i used string field type and its working.

But one thing is like string can hold upto the length of 255 but i need more length so i preferred to use memo field type and its not populating data's inside the delivery!

[isahore]

@Haricharan,

can you share your code where your are writing this memo field into the temp table, and then printing it in logInfo, and the last one where you are displaying it in your email?

[Haricharan]

Hi Ishan,

Please find the attached screenshot for the reference.

After updating memo description we can find the values populated in the display target

And updated the delivery screenshot where memo field updated using targetdata to populate the value

Please let me know what should i do to populate the values in the delivery

[Marcel_Szimonisz]

Hello @Haricharan,

I think you can only hold 255 characters when you create column within your workflow. 

• I did try to ALTER the temporary table column on fly

-- Alter the table to change the length of the varchar column to 2000
ALTER TABLE your_table
ALTER COLUMN your_column TYPE VARCHAR(2000);

• you can create schema and varchar field with as many charcters needed

  <attribute  length="5000" name="Memostring" type="string"/>

then try to copy your memo here within workflow


Marcel

[Haricharan]

Hi,

I updated the schema with the following attributes

<attribute  length="5000" name="Memostring" type="string"/>

And still could not able to populate more values!

Is there any other field can be used to populate more values.

[isahore]

@Haricharan,

Are you printing logInfo before or after saving the value in your temp table?

I tried the same way as you, and it worked.

If you right click on the outbound transition in your js activity, open.. go to the schema tab, what do you see as the datatype of your memodescription field? Is it string or long text?

BR,

Ishan

[Haricharan]

Hi Ishan,

It is long text and attaching the screenshot for the reference.

[isahore]

@Haricharan,

Are you printing logInfo before or after saving the value in your temp table?

Are you changing the data source back to snowflake after your js activity?

What happens when you display the target? See the data there or not?

[Haricharan]

Hi,

Im printing the value using loginfo before saving the value temp table.

As we discussed yesterday i could not change the data source again to ffda because i dont have external account for ffda

[isahore]

@Haricharan, If you are on v8, there has to be one ffda external account, just select the one that you see in the drop down for changing the data source.

[Haricharan]

Hi Ishan,

I do only have the following external accounts in the change data source