Skip to Main Content

Overview

This report template is used to display user comments and status updates.

Instructions

  1. In Page Designer, select a region
  2. Go to the Property Editor
  3. Under the Region tab
    1. Find Identification → Type, use Classic Report
  4. Under the Attributes tab
    1. Find Appearance → Template, use Comments

Demo

  • admin 5 weeks ago Delete
    Decommission servers - ADMIN (5 weeks ago)
  • admin 5 weeks ago Delete
    Measure effectiveness of improved QA - ADMIN (5 weeks ago)
  • admin 5 weeks ago Delete
    Response to Customer Feedback - ADMIN (5 weeks ago)
  • admin 5 weeks ago Delete
    User acceptance testing - ADMIN (5 weeks ago)
  • admin 5 weeks ago Delete
    End-user Training - ADMIN (5 weeks ago)
  • admin 5 weeks ago Delete
    Rollout sample applications - ADMIN (5 weeks ago)

Template Options

Substution Strings

#ACTIONS#
Actions for the comment
#ATTRIBUTE_1#
Additional attribute 1
#ATTRIBUTE_2#
Additional attribute 2
#ATTRIBUTE_3#
Additional attribute 3
#ATTRIBUTE_4#
Additional attribute 4
#COMMENT_DATE#
Date of the comment
#COMMENT_MODIFIERS#
CSS Class-based modifiers for a comment item
#COMMENT_TEXT#
Text of the comment
#ICON_MODIFIER#
CSS Class-based modifiers for comment icon
#USER_ICON#
CSS Class-based modifiers for user icon
#USER_NAME#
User name

Sample SQL Query

select
  p.id,
  apex_string.get_initials(p.created_by) user_icon,
  p.created comment_date,
  lower(p.created_by) user_name,
  ' ' comment_text,
  'Delete' actions,
  ' ' attribute_1,
  ' ' attribute_2,
  ' ' attribute_3,
  ' ' attribute_4,
  t.created task_created,
  t.created_by task_owner,
  t.task_name task_name,
  'u-color-'||ora_hash(p.created_by,45) icon_modifier
from
  eba_ut_chart_tasks t,
  eba_ut_chart_projects p
where
  t.project = p.id
order by t.created