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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

How to populate the inbound transition data in the alert activity

Avatar

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

Avatar

Correct answer by
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 --------------

1 Reply

Avatar

Correct answer by
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 --------------