Badge

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 Name	Start Date	End Date	Status	Budget
Decommission servers	04-MAY	01-AUG	Pending	$500.00
Measure effectiveness of improved QA	04-MAY	03-JUN	Pending	$1,500.00
Response to Customer Feedback	04-MAY	26-AUG	Pending	$6,000.00
User acceptance testing	19-MAY	21-AUG	Pending	$2,500.00
End-user Training	21-JUN	02-SEP	Pending	$2,500.00
Rollout sample applications	24-AUG	04-SEP	Pending	$500.00
Installation	06-MAY	05-JUN	Pending	$1,500.00
Notify users	07-JUN	10-JUN	Pending	$200.00
Plan production release schedule	24-MAR	24-MAR	Closed	$100.00
Complete questionnaire	20-MAR	04-APR	On-Hold	$800.00
Select servers for Development, Test, Production	04-FEB	09-FEB	Closed	$600.00
HR Support Systems	02-FEB	13-JUN	Closed	$500.00
HR software upgrades	02-FEB	30-MAY	On-Hold	$7,000.00
Arrange for vacation coverage	02-FEB	02-APR	On-Hold	$7,000.00
Complete plan	09-FEB	16-MAR	Closed	$1,500.00
Check software licenses	14-MAR	15-MAR	Closed	$200.00
Create training workspace	03-MAR	10-MAR	Closed	$700.00
Publish links to self-study courses	03-MAR	03-MAR	Closed	$100.00
Identify point solutions required	05-MAR	07-MAR	Closed	$300.00
Install in development	09-MAR	09-MAR	Closed	$100.00
Identify owners	20-FEB	23-FEB	Closed	$300.00
Initial Draft Review	24-FEB	24-FEB	Closed	$100.00
Monitor Review Comments	24-FEB	02-APR	Closed	$500.00
Implement bug tracking software	16-FEB	16-FEB	Closed	$100.00
Review automated testing tools	17-FEB	17-MAR	Closed	$1,500.00
Identify pilot applications	11-FEB	16-FEB	Closed	$500.00
Migrate pilot applications to	21-FEB	26-FEB	Closed	$500.00
Customize Software Projects software	18-MAR	22-APR	Open	$1,000.00
Post-migration review	03-MAR	03-MAR	Closed	$100.00
User acceptance testing	05-MAR	06-MAR	Closed	$200.00
Enter base data (Projects, Milestones, etc.)	12-MAR	13-MAR	Closed	$200.00
Load current tasks and enhancements	14-MAR	18-MAR	Closed	$500.00
Document quality assurance procedures	18-MAR	21-APR	On-Hold	$4,000.00
Conduct project kickoff meeting	07-MAR	07-MAR	Closed	$100.00
Determine host server	08-MAR	09-MAR	Closed	$200.00
Check software licenses	09-MAR	09-MAR	Closed	$100.00
Identify pilot users	07-MAR	08-MAR	Closed	$200.00
Software Deliverable	09-MAR	22-MAR	Closed	$500.00
Early Adopter Release	23-MAR	23-MAR	Closed	$100.00
Determine midtier configuration(s)	03-FEB	03-FEB	Closed	$100.00
Manage Training Activities	29-FEB	06-MAY	On-Hold	$2,000.00
Review feedback	11-APR	17-APR	On-Hold	$400.00
Plan rollout schedule	18-APR	26-APR	On-Hold	$750.00
Plan rollout schedule	12-MAR	04-APR	On-Hold	$1,000.00
Develop web pages	12-APR	18-MAY	On-Hold	$2,000.00
Purchase additional software licenses, if needed	20-MAY	20-MAY	On-Hold	$100.00
Investigate new Virus Protection software	31-MAR	15-APR	Open	$1,500.00
Get RFPs for new server	15-MAR	05-APR	Open	$1,000.00
Collect mission-critical spreadsheets	17-MAR	18-MAY	Open	$4,000.00
Create applications from spreadsheets	17-MAR	31-AUG	Open	$10,000.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.

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
Decommission servers	04-MAY	01-AUG	$500.00	Pending
Measure effectiveness of improved QA	04-MAY	03-JUN	$1,500.00	Pending
Response to Customer Feedback	04-MAY	26-AUG	$6,000.00	Pending
User acceptance testing	19-MAY	21-AUG	$2,500.00	Pending
End-user Training	21-JUN	02-SEP	$2,500.00	Pending
Rollout sample applications	24-AUG	04-SEP	$500.00	Pending
Installation	06-MAY	05-JUN	$1,500.00	Pending
Notify users	07-JUN	10-JUN	$200.00	Pending
Plan production release schedule	24-MAR	24-MAR	$100.00	Closed
Complete questionnaire	20-MAR	04-APR	$800.00	On-Hold

1 - 10

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

Overview

Demo: Interactive Report

Configuration: Interactive Report

Region

Status Column

Badge

Sample SQL Query: Interactive Report

Demo: Classic Report

Configuration: Classic Report

Region

Status Column

Sample SQL Query: Classic Report