User Manual

GETTING STARTED


OTHER EDITIONS


LAUNCHERS


MODULES


PLATFORM


APPENDIX


TUTORIALS & HELPFUL TRICKS


STRATEGIC PARTNER LINKS

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

RESOURCES

Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support

ALL USER MANUAL VERSIONS

Ignition 8.1. Offline Version (04/2021)
Ignition 8 Online Version
Ignition 7.9 Online Version
Ignition 7.8 Online Version

Deprecated Pages

SDK Documentation

Employees

Sign In

Skip to end of metadata
Go to start of metadata

This function is used by Ignition's Expression language.

Description
This function, which accepts any number of arguments, evaluates each in order, and returns the first non-null argument. A typical use case involves two arguments - the first being something dynamic, the second being a static value to use as a guard in case the dynamic value is null. The function itself detects its return type based on the type of the last argument.
Syntax

coalesce(value, [value, ...])

  • Parameters

Object value - Any number of values.

  • Returns

Object - The first non null argument.

Examples
Code Snippet
coalesce(null, "abc") //Would return "abc".
Code Snippet
coalesce("xyz", "abc") //Would return "xyz".
Code Snippet
coalesce({Root Container.MyDataSet}[0,"ColumnName"], 0) //Would return the value in the dataset if it isn't null, but 0 if it is null.
  • No labels