Use of variables/temp schema data in an alert
Hi Vipul,
Thank you for your response. Very much appreciated.
I can see that delivery template. It does exist, and my operator does have access.
I sent myself an alert which uses it via workflow with a simple "alert test" static HTML message and it worked - so I don't understand why i'm getting that error.
I've given more detail on the workflow where the error occurs below, if you can offer any further insight - that would be great.
Thanks
David
---
Workflow build
Deliveries info Query (query)
To return deliveries that have success ratio less than 95% in last month (messages to send > 99 )
Failed Logs Info Query (query2)
To get the failed recipient delivery logs for each the same deliveries
Group by and count by Email Domain
Failed Logs Info - Deduplication - Keep Top 5 Error Domains Per Delivery ID (dedup)
Keep the top 5 email domains per delivery
Failed Logs Info - Enrichment - Add an auto PK (enrich)
Enrichment activity just to add a PK for each record (I didn't know an alternative way, but without this step the next enrichment complained about no PK)
Enrichment 2 (enrich2)
Joins the top 5 failed recipient delivery logs to each delivery
Alert (alert)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<p>The following deliveries had a Success Ratio of less than 95%. The last column details the top 5 error domains.</p>
<%
var query = xtk.queryDef.create(
<queryDef
schema="temp:enrich2" operation="select">
<select>
<node expr="@deliveryFolder"/>
<node expr="@deliveryId"/>
<node expr="@deliveryLabel"/>
<node expr="@contactDate"/>
<node expr="@initialTargetPopulation"/>
<node expr="@messagesToSend"/>
<node expr="@processed"/>
<node expr="@success"/>
<node expr="@successRatio"/>
<node expr="@errors"/>
<node expr="[failedLogs/@emailDomain]"/>
<node expr="[failedLogs/@errorCount]"/>
</select>
</queryDef>
);
var items = query.ExecuteQuery();
%>
<table cellpadding="2" cellspacing="2" border="2">
<tr>
<td>Folder</td>
<td>Delivery ID</td>
<td>Delivery Label</td>
<td>Contact Date</td>
<td>Initial Target</td>
<td>Messages To Send</td>
<td>Processed</td>
<td>Success</td>
<td>Success Ratio</td>
<td>Errors</td>
<td>Top 5 Error Domains</td>
</tr>
<% for each (var item in items){%>
<tr>
<td><%= item.@deliveryFolder %></td>
<td><%= item.@deliveryId %></td>
<td><%= item.@deliveryLabel %></td>
<td><%= item.@contactDate %></td>
<td><%= item.@initialTargetPopulation %></td>
<td><%= item.@messagesToSend %></td>
<td><%= item.@processed %></td>
<td><%= item.@success %></td>
<td><%= item.@successRatio %></td>
<td><%= item.@errors %></td>
<td>
<% for each (var logs in item.failedLogs){%>
<%= logs.@emailDomain %>: <%= logs.@errorCount %><BR>
<% } %>
</td>
</tr>
<% } %>
</table>
</body>
</html>
Audit Logs
.png){kind=avatar}
Related Conversations
