By using this website, you agree to our Terms of Use (click here)
The final result is to email an Admin user a list of newly created or modified employees on a schedule.
for this I am using a Generic Inquiry: EP ADDS. Using CONDITIONS of the GI, I am receiving the records desired.
Next I created a Notification Template. This is where I am having difficulty as it only prints a single record where the GI is showing 4.
the text in the Notification is as follows:
<foreach view="EP Adds">
((EP_acctCD)) ((EP_acctCD_description)) ((EP_createdDateTime)) ((EP_createdByID_description))<br>
</Foreach>
the issue I believe is getting FOREACH VIEW to properly identified so it can change. I don't know what name it is expecting.
the email comes out like:
<foreach view="EP adds">
ISL105551 Isxxx, Jxxxxxx 2/21/2019 7:42:39 PM xxxxxx <br>
</Foreach>
(I replace text with xxxxxx to hide actual names.)
Please help...
I next have Business Event, on a schedule that produces the email. this runs well and I have not problems.
I recently had the same issue with a notification about orders that met a certain criteria in our inquiry. I wanted a single email showing all the orders that met this criteria and was having the same problem of only the first result showing at first.
I believe you need to drop the view="EP Adds" from the template. Try using the below instead and it should work. I also repeated this foreach loop for each data field that I wanted to show on my email template.
<foreach> ((EP_acctCD)) </foreach>
I would definitely go with a Business Event here. The Automation Notifications (SM205040) screen is now largely obsolete in my opinion.
Try switching to HTML view and edit the HTML directly so that it is valid. Also confirm the object name is correct. I used this many times without issue, but not for that table. Example:
<p class="richp"><table><tbody>
<tr></tr>
<tr><td>Supplier:</td><td><span data-field="yes">((vendor.AcctCD))</span> - <span data-field="yes">((vendor.AcctName))</span></td></tr>
<tr><td>Order Total:</td><td><span data-field="yes">((Document.CuryID.CurySymbol))((Document.CuryID.CuryID))</span> <span data-field="yes">((Document.CuryOrderTotal))</span></td></tr>
<tr><td>Description:</td><td><span data-field="yes">((Document.OrderDesc))</span></td></tr>
<tr><td valign="top">Order Items:</td><td><foreach view="Transactions">
<span data-field="yes">((Transactions.TranDesc))</span> <span data-field="yes">((Document.CuryID.CurySymbol))((Transactions.CuryLineAmt))</span> |
</foreach></td></tr>
<tr><td>Owner:</td><td><span data-field="yes">((Employee.DefContactID.FirstName))</span></td></tr>
</tbody></table></p>
You can also try using HTML entities for < and > enclosing the "foreach view" entity.