How to populate the inbound transition data in the alert activity

ramprakasht3196

08-10-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Nmn_shrm

08-10-2020

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

Answers (0)