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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi Ishan,
I have attached the screenshot for the change data source, kindly confirm and let me know.
Views
Replies
Total Likes
Views
Replies
Total Likes
I dont have FFDA external account, do you any other suggession to overcome this issue
Views
Replies
Total Likes
@Haricharan go ahead with the screenshot setting you shared in the previous comment. Let me know if that worked.
BR,
Ishan
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hello @Haricharan,
I think you can only hold 255 characters when you create column within your workflow.
-- Alter the table to change the length of the varchar column to 2000
ALTER TABLE your_table
ALTER COLUMN your_column TYPE VARCHAR(2000);
<attribute length="5000" name="Memostring" type="string"/>
then try to copy your memo here within workflow
Marcel
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi Ishan,
It is long text and attaching the screenshot for the reference.
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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
Views
Replies
Total Likes
@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.
Views
Replies
Total Likes
Hi Ishan,
I do only have the following external accounts in the change data source
Views
Replies
Total Likes