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.

...

on 8.1.8 release, add the following to the dataset parameters

Panel
titleSyntax

groupConcat(dataset, columnName, separator)

  • Parameters

Dataset dataset - The starting dataset.

String columnname - The name of the column to concatenate.

String separator - What will be used to separate each of the values.

  • Returns

String - A string with every value in the specified column of the specified dataset separated by the separator value.

Editor_notes


New_in
Version8.1.8


The following overload was introduced in 8.1.8. 

Panel
titleSyntax

groupConcat(collection, separator)

  • Parameters

Collection collection - The starting list, tuple, or set to use. 

String separator - What will be used to separate each of the values.

  • Returns

String - A string with every value in the specified collection separated by the separator value.


Panel
titleExamples

Suppose you had a table with this dataset in it:

Product CodeQualityWeight
BAN_0023803.243
BAN_0101209.928
APL_0001251.287
FWL_2203227.889


Code Block
languageactionscript3
titleCode Snippet
groupConcat({Root Container.Table.data}, 1, " / ")  //Would return the string: "380 / 120 / 125 / 322".


Code Block
languageactionscript3
titleCode Snippet
groupConcat({Root Container.Table.data}, "ProductCode", ", ")  //Would return the string: "BAN_002, BAN_010, APL_000, FWL_220".


...