


Hi team,
I had created custom table and the critical workflow status will be stored every day in the custom table. I need to send the daily records from custom table to workflow supervisor group. I used query activity to get the records from custom table post to that I added the alert activity to send email. In alert activity I need to populate the queried records in the table format. Could you please help me how to populate the queried records in table format in the alert activity?
Thanks,
Ram
Views
Replies
Sign in to like this content
Total Likes
You can query data from schema
Please find below the code you can use to populate the data in tabular format in alert activity:
------------------------ Code Start -----------------------------------
var query = xtk.queryDef.create(
<queryDef schema="temp:query6" operation="select">
<select>
<node expr="@xyz"/>
<node expr="@abc"/>
</select>
<orderBy>
<node expr="@xyz" sortDesc="true"/>
</orderBy>
</queryDef>);
var res = query.ExecuteQuery();
%> <BR>
<TABLE>
<THEAD>
<TR>
<TH>XYZ</TH>
<TH>ABC</TH>
</TR></THEAD>
<TBODY><%
for each(var record in res)
{%>
<TR>
<TD><%= record.@xyz %></TD>
<TD><%= record.@abc %></TD>
</TR><%
}
%> </TBODY></TABLE>
-------------------- Code End --------------
You can query data from schema
Please find below the code you can use to populate the data in tabular format in alert activity:
------------------------ Code Start -----------------------------------
var query = xtk.queryDef.create(
<queryDef schema="temp:query6" operation="select">
<select>
<node expr="@xyz"/>
<node expr="@abc"/>
</select>
<orderBy>
<node expr="@xyz" sortDesc="true"/>
</orderBy>
</queryDef>);
var res = query.ExecuteQuery();
%> <BR>
<TABLE>
<THEAD>
<TR>
<TH>XYZ</TH>
<TH>ABC</TH>
</TR></THEAD>
<TBODY><%
for each(var record in res)
{%>
<TR>
<TD><%= record.@xyz %></TD>
<TD><%= record.@abc %></TD>
</TR><%
}
%> </TBODY></TABLE>
-------------------- Code End --------------