Skip to Main Content

Overview

Content Row is a Classic Report template that is suitable for displaying most types of content. This report features a column for selection such as a checkbox or radio button, an icon, title and description, miscellaneous attributes, and actions.

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 Content Row

Demo

Template Options

Column Names

#ACTIONS#
Use this to display a button or other actions
#DESCRIPTION#
Description or text of the content
#ICON_CLASS#
Icon of the content row. Please prefix with "fa" when using Font APEX.
#ICON_HTML#
Use this to display custom HTML in place of the icon, for example an image tag.
#ITEM_CLASSES#
CSS Class-based modifiers for the content row item
#MISC#
This displays adjacent actions column and can be used for showing user information or last updated date.
#SELECTION#
Use this to add a checkbox or radio button for selection
#TITLE#
Title column, typically the link

Sample SQL Query

select
  null item_classes,
  null selection,
  case t.status 
    when 'Open' then 'fa fa-lg fa-exclamation-circle-o'
    when 'Closed' then 'fa fa-lg fa-check-circle u-success-text'
    when 'On-Hold' then 'fa fa-lg fa-minus-circle u-danger-text'
    when 'Pending' then 'fa fa-lg fa-exclamation-triangle u-warning-text'
  end icon_class,
  null icon_html,
  t.task_name title,
  'Project: ' || p.project description,
  t.status misc,
  null actions
from
  eba_ut_chart_tasks t,
  eba_ut_chart_projects p
where
  t.project = p.id
order by p.created