Displaying WFMSGDTL in workflow emails.

 6 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Brian Espe
Basic Member Send Private Message
Posts: 7
Basic Member
Currently we are retrieving data from the wfmsgdtl table and displaying it in our flow emails.  When there are multiple messages for the same workunit it just strings them together.  We would like these to be on a separate line in the email.
John Henley
Send Private Message
Posts: 3351
How are you generating the mail message? Are you using the msgbuilder node inside a loop over a wfmsgdtl query? If so, you should just have to hit enter after the variable name in the msgbuilder node's content, and it will put them on separate lines.
Thanks for using the LawsonGuru.com forums!
John
Robert Spurr
Veteran Member Send Private Message
Posts: 130
Veteran Member
If you are using HTML tagging you could just add "
"
to the end of each record returned if not \r - Just a thought
Robert Spurr
Veteran Member Send Private Message
Posts: 130
Veteran Member
It removed the break tag from my resopnse "
"
Brian Espe
Basic Member Send Private Message
Posts: 7
Basic Member
John,
If I understand what you are saying, in our MsgBuilder node I went to the end of
and hit enter which took me to the next line.  I saved the flow and uploaded to the server and then tried the process again.  Here are the results in the email.
Testing the message detail within an email. I am rejecting this. Need you to do a different order.

I was hoping to get it to look like this.
Testing the message detail within an email.
I am rejecting this. Need you to do a different order.
John Henley
Send Private Message
Posts: 3351
Are you using HTML content email or plain text?
How many result rows are in WFMSGDTL?
Thanks for using the LawsonGuru.com forums!
John
Brian Espe
Basic Member Send Private Message
Posts: 7
Basic Member
John,
Good Question on the content.  This specific example has two messages in the table.