Board Expressions

Unified Command Platform has a built-in <expression> tag for running expressions. An expression in programming is a combination of literals, variables, operators, and function calls that produce a value when evaluated. In Unified Command Platform, expressions work like the SELECT statement in Structured Query Language (SQL). When building boards in Unified Command Platform and DesignStudio, you can use expressions to calculate, identify, and verify board values. For example, you might use expressions to find the difference between two fields, count records with a certain status, or verify that field values are valid.

If you are familiar with SQL and want to learn how to use expressions with Unified Command Platform boards, the tables below provide examples to help you get started.

Refer to the Expressions/T-SQL Quick Reference Guide for many examples of expressions that can be used in Unified Command Platform.

After Action Review

After Action Review board expressions
Expression Description	Expression
Total AARs with a Status of Open	`<expression name="exp_total_open" filter="status = 'Open' AND remove != 'Yes'">COUNT(*)</expression>`
Total Low Priority AARs	`<expression name="exp_total_low">ISNULL(SUM(CASE WHEN priority = 'Low' AND remove != 'Yes' THEN 1 ELSE 0 END), 0)</expression>`
Total Improvement Plans Included	`<expression name="exp_total_plan_included">ISNULL(SUM(CASE WHEN improvement_plan = 'Included' AND remove != 'Yes' THEN 1 ELSE 0 END), 0)</expression>`

Event Reporting

Event Reporting board expressions
Expression Description	Expression
Total Critical Events	`<expression name="exp_total_critical">ISNULL(SUM(CASE WHEN status = 'Critical' THEN 1 ELSE 0 END), 0)</expression>`
Total Not Reviewed	`<expression name="exp_total_not_reviewed">ISNULL(SUM(CASE WHEN controller_review_status = 'Not Reviewed' THEN 1 ELSE 0 END), 0)</expression>`
Total Significant Events/Posted	`<expression name="exp_total_posted" filter="controller_review_status = 'Posted' AND remove != 'Yes'">COUNT(*)</expression>`

Facility Status

Facility Status board expressions
Expression Description	Expression
Total Operational Facilities	`<expression name="exp_total_operational" filter="status = 'Operational' AND remove != 'Yes'">COUNT(*)</expression>`
Utility Internet Status (display “Unknown” if value is null or empty)	`<expression name="utility_internet_status_value">CASE WHEN utility_internet_status = '' OR utility_internet_status IS NULL THEN 'Unknown' ELSE utility_internet_status END</expression>`
Utility Power Status (display “Unknown” if value is null or empty)	`<expression name="utility_power_status_value">CASE WHEN utility_power_status = '' OR utility_power_status IS NULL THEN 'Unknown' ELSE utility_power_status END</expression>`

Requests and Tasks

Requests and Tasks board expressions
Expression Description	Expression
Total Requests	`<expression name="exp_total_requests">COUNT(*)</expression>`
Total Active Requests	`<expression name="exp_requests_active">SUM(CASE WHEN status != 'Cancelled' AND status != 'Closed' AND status != 'Complete' THEN 1 ELSE 0 END)</expression>`
Total Completed/Closed Requests	`<expression name="exp_requests_completedclosed">SUM(CASE WHEN (status = 'Complete' OR status = 'Closed') THEN 1 ELSE 0 END)</expression>`
Total Closed Deployments	`<expression name="exp_total_closed">ISNULL(SUM(CASE WHEN deployment_status = 'Completed' OR deployment_status = 'Demobilized' OR deployment_status = 'Cancelled' THEN 1 ELSE 0 END), 0)</expression>`

Shelters

Shelters board expressions.
Expression Description	Expression
Total Capacity of All Shelters	`<expression name="total_capacity">SUM(capacity)</expression>`
Calculate Availability	`<expression name="availability">capacity-occupancy</expression>`
Total Open Shelters	`<expression name="total_open_shelters">SUM(CASE WHEN status = 'OPEN' THEN 1 ELSE 0 END)</expression>`

Related Concepts

Expressions/T-SQL Quick Reference Guide