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

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Expression_function


Panel
titleDescription
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.
Panel
titleSyntax

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

  • Parameters

Object value - Any number of values.

  • Returns

Object - The first non null argument.

Panel
titleExamples
Code Block
languageactionscript3
titleCode Snippet
coalesce(null, "abc") //Would return "abc".
Code Block
languageactionscript3
titleCode Snippet
coalesce("xyz", "abc") //Would return "xyz".
Code Block
languageactionscript3
titleCode 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.