Print

Comment Bubbles template explained

Written by Mandy. Posted in Report Layout.

In Template 25 (Blue Responsive) there is a Report Template called "Comment Bubbles" which you can apply to your report.

This is handy for notes that belong to a parent record, as well as useful for displaying audit information to users.

commentbubbles

I'm using APEX Version 4.2.0.00.27 

Query Format:

The query needs to contain the following columns in order:

select
class,
note_type,
note_text,
attribute_1,
attribute_2,
attribute_3,
attribute_4,
created_by,
created_on,
link,
created,
note_id
from
...

 

Attributes & Options

Ref. No Attribute (Column) Description Options, Examples
1 class The class of the bubble which affects the style in which it is displayed.

[null] - displays a yellow bubble

grayComment - displays a grey bubble

2 note_type The 'type' of the update - you may have notes, auditing updates, etc within the same report feed. Dislays bold, grey and in italics.  
3 note_text The main text/description that is displayed in the update.  
4 attribute_1 Displayed as text within the bubble, following the 'note_text'  
5 attribute_2 Displayed as text within the bubble, following 'attribute_1' Can use <stong> tags to make text appear bold
6 attribute_3 Displayed as text within the bubble, following 'attribute_2'  
7 attribute_4 Displayed as text within the bubble, following 'attribute_3'   
8 created_by Displays small, underneath the bubble on the far left. Usually used to display the data stored in the CREATED_BY column of the table's audit columns, usually populated by a trigger with the person who is currently logged into the session.  
9 created_on

Displays small, underneath the button, beside the 'created_by'. Usually used to display the data stored in the CREATED column of the table's audit columns, usually populated by a trigger at the time of creation.

Use function apex_util.get_since(mydate) to display the time from now.

 

To display like below:

apex_util.get_since(n.created) ||' - '||to_char(n.created,'Day DD-MON-YYYY HH24:MI') as "created_on"

10 link Displays the link with text. The properties of the text displayed can be defined in Report Attributes > Column Attributes > Column Link  #link (and then define the link in the 'Report Attributes')
11 created Used for sorting. Not displayed in template.  
12 note_id Unique ID of the note. Used if you require an 'Edit' link. Not displayed in template.  

 

commentbubbles example

Check out Oracle's packaged app, "Customer Tracker". Take a look at the Comment Bubble region on page 50 for an example of how this is implemented.

About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2