How to populate the inbound transition data in the alert activity

[ramprakasht3196]

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

[Nmn_sharma · Accepted solution]

@ramprakasht3196

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 --------------