We are new to dynamic content blocks (and scripting with jelly) and need to present data (e.g., Accomplishments Since Last Reporting Period, Key Activities Planned, etc.) from the most recent project status reports for all active projects under a given program. The script below returns data from the most recent report in the table; how can it be modified to return the results stated above?
Thank you
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<g2:evaluate>
var ex=new GlideRecord('project_status');
ex.orderByDesc('as_on');
ex.setLimit(1);
ex.query();
</g2:evaluate>
<table width = "95%">
<tr class="header">
<td colspan="3"> </td>
</tr>
<tr>
<th style="background-color:#DBE9FA" class="text-center"><br>Status Date</br></th>
<th style="background-color:#DBE9FA" class="text-center"><br>Accomplishments Since Last Reporting Period</br></th>
<th style="background-color:#DBE9FA" class="text-center"><br>Key Activities Planned</br></th>
</tr>
<j2:while test="$[ex.next()]">
<tr>
<td> $[ex.getValue('as_on')] </td>
<td> $[ex.getValue('achievements_last_week')] </td>
<td> $[ex.getValue('key_activities_next_week')] </td>
</tr>
</j2:while>
</table>
</j:jelly>
