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
End-user Training	11-AUG	06-OCT	Open	$2,000.00
Identify server requirements	15-JUN	16-JUN	Closed	$200.00
Specify security authentication scheme(s)	17-JUN	19-JUN	Closed	$300.00
Create pilot workspace	24-JUN	24-JUN	Closed	$100.00
Configure Workspace provisioning	24-JUN	24-JUN	Closed	$100.00
Run installation	25-JUN	25-JUN	Closed	$100.00
Obtain equipment specifications	17-AUG	20-AUG	Pending	$500.00
Purchase backup server	26-AUG	21-SEP	Pending	$3,000.00
Identify integration points	22-AUG	11-SEP	Pending	$2,000.00
Decommission machines	22-AUG	22-AUG	Pending	$100.00
Map data usage	03-SEP	16-OCT	Pending	$8,000.00
Purchase new machines	08-OCT	02-NOV	Pending	$2,500.00
Import data	09-OCT	05-NOV	Pending	$1,000.00
Convert processes	16-SEP	14-NOV	Pending	$3,000.00
Decommission servers	15-SEP	13-DEC	Pending	$500.00
Measure effectiveness of improved QA	15-SEP	15-OCT	Pending	$1,500.00
Response to Customer Feedback	15-SEP	07-JAN	Pending	$6,000.00
User acceptance testing	30-SEP	02-JAN	Pending	$2,500.00
End-user Training	02-NOV	14-JAN	Pending	$2,500.00
Rollout sample applications	05-JAN	16-JAN	Pending	$500.00
Installation	17-SEP	17-OCT	Pending	$1,500.00
Notify users	19-OCT	22-OCT	Pending	$200.00
Plan production release schedule	05-AUG	05-AUG	Closed	$100.00
Complete questionnaire	01-AUG	15-AUG	On-Hold	$800.00
Select servers for Development, Test, Production	17-JUN	22-JUN	Closed	$600.00
HR Support Systems	15-JUN	25-OCT	Closed	$500.00
HR software upgrades	15-JUN	11-OCT	On-Hold	$7,000.00
Arrange for vacation coverage	15-JUN	14-AUG	On-Hold	$7,000.00
Complete plan	22-JUN	28-JUL	Closed	$1,500.00
Check software licenses	26-JUL	27-JUL	Closed	$200.00
Create training workspace	15-JUL	22-JUL	Closed	$700.00
Publish links to self-study courses	15-JUL	15-JUL	Closed	$100.00
Identify point solutions required	17-JUL	19-JUL	Closed	$300.00
Install in development	21-JUL	21-JUL	Closed	$100.00
Identify owners	03-JUL	06-JUL	Closed	$300.00
Initial Draft Review	07-JUL	07-JUL	Closed	$100.00
Monitor Review Comments	07-JUL	14-AUG	Closed	$500.00
Implement bug tracking software	29-JUN	29-JUN	Closed	$100.00
Review automated testing tools	30-JUN	29-JUL	Closed	$1,500.00
Identify pilot applications	24-JUN	29-JUN	Closed	$500.00
Migrate pilot applications to	04-JUL	09-JUL	Closed	$500.00
Customize Software Projects software	29-JUL	03-SEP	Open	$1,000.00
Post-migration review	15-JUL	15-JUL	Closed	$100.00
User acceptance testing	17-JUL	18-JUL	Closed	$200.00
Enter base data (Projects, Milestones, etc.)	24-JUL	25-JUL	Closed	$200.00
Load current tasks and enhancements	26-JUL	30-JUL	Closed	$500.00
Document quality assurance procedures	30-JUL	02-SEP	On-Hold	$4,000.00
Conduct project kickoff meeting	19-JUL	19-JUL	Closed	$100.00
Determine host server	20-JUL	21-JUL	Closed	$200.00
Check software licenses	21-JUL	21-JUL	Closed	$100.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
End-user Training	11-AUG	06-OCT	$2,000.00	Open
Identify server requirements	15-JUN	16-JUN	$200.00	Closed
Specify security authentication scheme(s)	17-JUN	19-JUN	$300.00	Closed
Create pilot workspace	24-JUN	24-JUN	$100.00	Closed
Configure Workspace provisioning	24-JUN	24-JUN	$100.00	Closed
Run installation	25-JUN	25-JUN	$100.00	Closed
Obtain equipment specifications	17-AUG	20-AUG	$500.00	Pending
Purchase backup server	26-AUG	21-SEP	$3,000.00	Pending
Identify integration points	22-AUG	11-SEP	$2,000.00	Pending
Decommission machines	22-AUG	22-AUG	$100.00	Pending

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