Expand my Community achievements bar.

memo description is not working

Avatar

Level 2

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.

 

 

22 Replies

Avatar

Community Advisor

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

Avatar

Level 2

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.

 

 

Avatar

Community Advisor

@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

Avatar

Level 2

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.

 

Avatar

Community Advisor

@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

Avatar

Level 2

Hi Ishan,

 

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

 

Haricharan_0-1706611325263.png

 

Avatar

Community Advisor

@Haricharan,

this should work if you have only ffda external account.

 

BR,

Ishan

Avatar

Level 2

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

Avatar

Community Advisor

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

 

BR,

Ishan

Avatar

Level 2

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!

Avatar

Community Advisor

@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?

Avatar

Level 2

Hi Ishan,

 

Please find the attached screenshot for the reference.

Haricharan_0-1706629956928.png

 

Haricharan_1-1706630015830.png

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

 

Haricharan_2-1706630142484.png

 

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

 

Haricharan_3-1706630239835.png

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

 

Avatar

Community Advisor

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

Avatar

Level 2

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.

  

Avatar

Community Advisor

@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?

isahore_0-1706700666773.png

BR,

Ishan

Avatar

Level 2

Hi Ishan,

 

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

 

Haricharan_0-1706701205862.png

 

Avatar

Community Advisor

@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?

isahore_0-1706702524539.png

 

 

Avatar

Level 2

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

Avatar

Community Advisor

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

isahore_0-1706702692656.png

 

Avatar

Level 2

Hi Ishan,

 

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

Haricharan_0-1706702902198.png