SILog map styles

Från DataPolarna
Hoppa till navigering Hoppa till sök

Conditions

Compare operators that can be used are

  • =
  • >
  • >=
  • <
  • <=

Conditions can use and or or for validation.

Text can be concatenate using &

Functions

ANYOF

TODO: Add info

COALESCE

Use the first value that isn't null.

Example

COALESCE(product.name, storageArea.name)

Will show the name of the storage area if there isn't any product in the storage area.

IF

Match a single condition

Example

IF(storageArea.status = storageAreaStatus.empty, "Empty", "Not empty")

will return Empty for storage area with status empty

IFS

MAX

Returns the MAX value of two or more values

Example

MAX(1, 3, 2)

will return 3

MIN

Returns the MIN value of two or more values

Example

MAX(42, 1, 100)

will return 1

NOT

Match a negative condition

Example

IF(NOT(storageArea.status = storageAreaStatus.empty), "Not empty", "Empty")

Will return Not empty for any storage that doesn't have status empty

ROUND

Round a value to specified number of digits

Example

ROUND(123.456, 2)

will return 123.46

SWITCH