Collections
Collections allow you to group list objects together. Collections are available in both APEX Report templates and APEX List templates.
Basic
  • Basic

  • BLAKE    
  • CLARK 2  
  • JONES 1  
  • KING    
  • SCOTT    
Selected Template Options

Basic
Template: Standard

Template OptionValue(s)Comments
Use DefaultYes
Links
Headers
  • Headers

  • BLAKE    
  • CLARK    
  • SCOTT    
  • KING    
  • JONES    
Selected Template Options

Headers
Template: Standard

Template OptionValue(s)Comments
Use DefaultYes
With HeaderYes
Using APEX Lists
Secondary Content
Template Options
Template Options

Template Options
Template: Standard

Template OptionValue(s)Comments
With HeaderYes
Substitution Strings
  • Substitution Strings

  • #TEXT# Text of the collection item  
  • #LINK# Link of the collection item  
  • #BADGE# Text or number that appears to the right of the collection item  
  • #NEW_BADGE# Flag to highlight the badge. Can be anything (not null)  
  • #SECONDARY_LINK# Link that applies to the secondary icon  
  • #SECONDARY_ICON# Icon name that appears to the right of the collection item  
Sample Query
select 'BLAKE' text
    , null badge
    , null new_badge
    , '#' secondary_link
    , 'send' secondary_icon
from dual