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

How to populate the inbound transition data in the alert activity

Avatar

Avatar
Boost 5
Level 2
ramprakasht3196
Level 2

Likes

9 likes

Total Posts

44 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
ramprakasht3196
Level 2

Likes

9 likes

Total Posts

44 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
ramprakasht3196
Level 2

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)

Avatar

Avatar
Boost 1
Level 1
Nmn_sharma
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
Nmn_sharma
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

2 solutions
Top badges earned
Boost 1
Affirm 1
View profile
Nmn_sharma
Level 1

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)