Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Displaying WFMSGDTL in workflow emails.

 6 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Brian Espe
Basic Member
Posts: 7
Basic Member
3/5/2013 1:16 AM
    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
    Posts: 3353
    3/5/2013 1:15 PM
      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
      Posts: 130
      Veteran Member
      3/5/2013 8:48 PM
        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
        Posts: 130
        Veteran Member
        3/5/2013 9:11 PM
          It removed the break tag from my resopnse "
          "
          Brian Espe
          Basic Member
          Posts: 7
          Basic Member
          3/6/2013 12:38 AM
            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
            Posts: 3353
            3/6/2013 3:18 PM
              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
              Posts: 7
              Basic Member
              3/6/2013 8:33 PM
                John,
                Good Question on the content.  This specific example has two messages in the table.