Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to populate the inbound transition data in the alert activity

ramprakasht3196
Level 3
Level 3

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

1 Accepted Solution
Nmn_sharma
Correct answer by
Level 1
Level 1

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

View solution in original post

1 Reply
Nmn_sharma
Correct answer by
Level 1
Level 1

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

View solution in original post