Skip to Main Content

Overview

The Badge partial is useful for displaying badges or counters. This partial can be used to display a single badge, or can be applied in report templates to display a badge for each report row.

Demo: Interactive Report

Task NameStart DateEnd DateStatusBudget
Create applications from spreadsheets07-AUG21-JAN Open $10,000.00
Lock spreadsheets07-AUG21-JAN Open $800.00
Send links to previous spreadsheet owners08-AUG23-JAN Open $1,500.00
Customize solutions31-JUL23-OCT Open $4,000.00
Train developers / users02-SEP16-NOV Pending $8,000.00
Implement in Production19-AUG25-DEC Open $1,500.00
Migrate applications07-AUG13-OCT Open $8,000.00
Plan migration schedule14-AUG25-OCT Open $6,000.00
Publish Feedback application18-AUG26-DEC Open $12,000.00
Train developers on tracking bugs12-SEP01-NOV On-Hold $2,000.00
End-user Training20-AUG15-OCT Open $2,000.00
Identify server requirements24-JUN25-JUN Closed $200.00
Specify security authentication scheme(s)26-JUN28-JUN Closed $300.00
Create pilot workspace03-JUL03-JUL Closed $100.00
Configure Workspace provisioning03-JUL03-JUL Closed $100.00
Run installation04-JUL04-JUL Closed $100.00
Obtain equipment specifications26-AUG29-AUG Pending $500.00
Purchase backup server04-SEP30-SEP Pending $3,000.00
Identify integration points31-AUG20-SEP Pending $2,000.00
Decommission machines31-AUG31-AUG Pending $100.00
Map data usage12-SEP25-OCT Pending $8,000.00
Purchase new machines17-OCT11-NOV Pending $2,500.00
Import data18-OCT14-NOV Pending $1,000.00
Convert processes25-SEP23-NOV Pending $3,000.00
Decommission servers24-SEP22-DEC Pending $500.00
Measure effectiveness of improved QA24-SEP24-OCT Pending $1,500.00
Response to Customer Feedback24-SEP16-JAN Pending $6,000.00
User acceptance testing09-OCT11-JAN Pending $2,500.00
End-user Training11-NOV23-JAN Pending $2,500.00
Rollout sample applications14-JAN25-JAN Pending $500.00
Installation26-SEP26-OCT Pending $1,500.00
Notify users28-OCT31-OCT Pending $200.00
Plan production release schedule14-AUG14-AUG Closed $100.00
Complete questionnaire10-AUG24-AUG On-Hold $800.00
Select servers for Development, Test, Production26-JUN01-JUL Closed $600.00
HR Support Systems24-JUN03-NOV Closed $500.00
HR software upgrades24-JUN20-OCT On-Hold $7,000.00
Arrange for vacation coverage24-JUN23-AUG On-Hold $7,000.00
Complete plan01-JUL06-AUG Closed $1,500.00
Check software licenses04-AUG05-AUG Closed $200.00
Create training workspace24-JUL31-JUL Closed $700.00
Publish links to self-study courses24-JUL24-JUL Closed $100.00
Identify point solutions required26-JUL28-JUL Closed $300.00
Install in development30-JUL30-JUL Closed $100.00
Identify owners12-JUL15-JUL Closed $300.00
Initial Draft Review16-JUL16-JUL Closed $100.00
Monitor Review Comments16-JUL23-AUG Closed $500.00
Implement bug tracking software08-JUL08-JUL Closed $100.00
Review automated testing tools09-JUL07-AUG Closed $1,500.00
Identify pilot applications03-JUL08-JUL Closed $500.00
  • 1 - 50

Region

Type: Interactive Report

Status Column

In Interactive Reports, the Badge partial is available for use as a column Type. The Status column in this demo uses the Badge column type and associated Partial settings to display a badge in each row.

Badge

Label: Status
Value: #STATUS#
Icon: None
Display Label: No
Style: Default
Shape: Default
Size: Default 

select ID,
       TASK_NAME,
       START_DATE,
       END_DATE,
       STATUS,
       ASSIGNED_TO,
       COST,
       BUDGET,
       case STATUS
         when 'Closed'  then 'success'
         when 'Open'    then 'danger'
         when 'Pending' then 'warning'
         else 'info'
       end as BADGE_STATE,
       case STATUS
         when 'Closed'  then 'fa-check'
         when 'Open'    then 'fa-exclamation'
         when 'Pending' then 'fa-question'
         else 'fa-info'
       end as BADGE_ICON
  from EBA_UT_CHART_TASKS

Demo: Classic Report

Task Name
Start Date
End Date
Budget
Status
Create applications from spreadsheets07-AUG21-JAN$10,000.00 Open
Lock spreadsheets07-AUG21-JAN$800.00 Open
Send links to previous spreadsheet owners08-AUG23-JAN$1,500.00 Open
Customize solutions31-JUL23-OCT$4,000.00 Open
Train developers / users02-SEP16-NOV$8,000.00 Pending
Implement in Production19-AUG25-DEC$1,500.00 Open
Migrate applications07-AUG13-OCT$8,000.00 Open
Plan migration schedule14-AUG25-OCT$6,000.00 Open
Publish Feedback application18-AUG26-DEC$12,000.00 Open
Train developers on tracking bugs12-SEP01-NOV$2,000.00 On-Hold

Region

Type: Classic Report

Status Column

The Status column uses the with-apply syntax in the HTML Expression attribute under Column Formatting to access the Badge partial and display a badge in each row.

Type: Plain Text
HTML Expression: {with/} LABEL:=STATUS VALUE:=#STATUS# STATE:=#BADGE_STATE# ICON:=#BADGE_ICON# LABEL_DISPLAY:=N STYLE:=t-Badge--subtle SHAPE:=t-Badge--circle {apply THEME$BADGE/} 

select ID,
       TASK_NAME,
       START_DATE,
       END_DATE,
       STATUS,
       ASSIGNED_TO,
       COST,
       BUDGET,
       case STATUS
         when 'Closed'  then 'success'
         when 'Open'    then 'danger'
         when 'Pending' then 'warning'
         else 'info'
       end as BADGE_STATE,
       case STATUS
         when 'Closed'  then 'fa-check'
         when 'Open'    then 'fa-exclamation'
         when 'Pending' then 'fa-question'
         else 'fa-info'
       end as BADGE_ICON
  from EBA_UT_CHART_TASKS