1. Home
  2. Knowledge Base
  3. General Shibumi Knowledge
  4. Solution Design
  5. Business Logic
  6. Expressions
  7. Functions
  8. unionIf()
Searching...

unionIf()

Contents

The join() function provides the ability to convert a list of values into a formatted, filterable text string.

Syntax

unionIf(Template API Name, value, condition)

Argument Description
Template API Name

(required)

 The template API name OR an association of the template instances containing the value to be summed.
value

(required)

 The value to be summed. 

The value arguments can be constants (i.e., hard-coded values or attribute references) and/or references to metrics. The value argument can also be a mathematical equation.
condition

(optional)

 The filter that determines which values to be included in the sum total. 

Notes

  • The filter can include “and” and “or” to further clarify the result set to include.
  • The “active=true” or “active=false” filter can be used to restrict the result set to specifically Active or specifically Inactive work items.  Not including this filter will retrieve all instances.
  • An abbreviation for “active=true” is simply “active”

Where Available

Available in all places the expression or injected expression icon is visible except for Metric expressions.

Examples

Where Example(s)
Text Attribute Calculated Expression unionIf(Territory__t, name, Region__c = "Europe")

unionIf(Territory__t, name, Region__c = "North America")
Updated on May 4, 2026

Related Articles