To show last updated rows inside a report isn't as hard as it sounds.
All you need is a time column which saves the insert date and some changes on your report template!
Go into your report template and change it like this:
In this example all rows which are younger than 10 minutes will be shown with a different background color. Which is defined inside the CSS class.
All you need is a time column which saves the insert date and some changes on your report template!
Go into your report template and change it like this:
Column Template 1:
<td class="new_css_class_with_different_color" #ALIGNMENT# id="#COLUMN_HEADER#_#COLNUM#_#ROWNUM#">#COLUMN_VALUE#</td>
PL/SQL Condition:
to_date('#DATE_COLUMN#','DD.MM.YYYY HH24:MI:SS') > (SYSDATE - INTERVAL '10' MINUTE)
Column Template 2:
<td class="old_css_class" #ALIGNMENT# id="#COLUMN_HEADER#_#COLNUM#_#ROWNUM#">#COLUMN_VALUE#</td>
In this example all rows which are younger than 10 minutes will be shown with a different background color. Which is defined inside the CSS class.
