SILog map styles: Skillnad mellan sidversioner

Från DataPolarna
Hoppa till navigering Hoppa till sök
Rad 90: Rad 90:


== SWITCH ==
== SWITCH ==
TODO

Versionen från 22 oktober 2025 kl. 15.01

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

Can have multiple conditions with value, a single value at the end will be used as default value.

Example

IFS(
storageArea.fillLevel >= 50 and storageArea.fillLevel < 80, "#4caf05",
storageArea.fillLevel >= 80 and storageArea.fillLevel < 90, "#ff8800",
storageArea.fillLevel >= 90, "#ff1500",
"#b0b0b0"
)

will set different color depending on fill level. If it is less then 50% then it uses "#b0b0b0"

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

TODO