Skip to main content
Version: 7.9

min

This function is used by Ignition's Expression language.

Description

Finds and returns the minimum value in the given column of the given dataset, or the min value in a series of numbers specified as arguments. When looking up the min in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, null is returned.

Syntax

min(dataset, columnIndex)

  • Parameters

    • DataSet dataset - The dataset to search through.

    • int columnIndex - The index of the column to search through. Must be a column index of the provided dataset.

  • Returns

    • int - The minimum value in that column.

Syntax

min(dataset, columnName)

  • Parameters

    • DataSet dataset - The dataset to search through.

    • string columnName - The name of the column to search through. Must match a column name in the provided dataset.

  • Returns

    • int - The minimum value in that column.

Syntax

min(value[, value...])

  • Parameters

    • int/float value - A number. Can be as many values as needed. Can be either a float or an integer.
  • Returns

    • int - The minimum value in the list of values.

Examples

For example, suppose you had a table with this dataset in it:

ProductCodeQuantityWeight
BAN_0023803.243
BAN_0101209.928
APL_0001251.287
FWL_2203227.889
Code Snippet
min({Root Container.Table.data}, 1) //... would return 120
Code Snippet
min(0, 10/2, 3.14) //... would return 0
Code Snippet
min({SomeValue}, 180) //This example is a great way to make sure a value never goes above 180