Vincent Morneau
Badges
Badges can notify you that there are new or unread messages or notifications.
In Collections

  • In Collections

  • CLARK 10
  • SCOTT 4
  • KING 6
  • JONES 6 new
  • BLAKE 9
Selected Template Options
Component Name: In Collections
Template: Standard
Template OptionValue(s)Comments
Use DefaultYes
Custom AttributeValue
Report TemplateCollection
Sample Query
select 'JONES' text
    , round(dbms_random.value(1,10)) || ' new' badge
    , 'Y' new_badge
    , null secondary_link
    , null secondary_icon
from dual
In Dropdown
Click me
report error:
ORA-00942: table or view does not exist
Selected Template Options
Component Name: Click me
Template: Standard
Template OptionValue(s)Comments
Use DefaultYes
Dropdown WidthSame as button (trigger)
Custom AttributeValue
Report TemplateDropdown
Sample Query
select ename display
      , '#' target
      , round(dbms_random.value(1,10)) badge
      , decode(ename, 'JONES', 'Y') new_badge
from emp
where rownum <= 5