Visa källa för SILog map styles

= Conditions =
Compare operators that can be used are
* '='
* '>'
* '>='
* '<' 
* '<='

Conditions can use '''and'''
<pre>
IF(inside and selected, "inside and selected", "")
</pre>

or '''or''' in the condition to check for multiple things

<pre>
IF(inside or selected, "inside or selected", "")
</pre>

Text can be concatenate using '''&'''
<pre>
storageArea.name & " " & product.name
</pre>

= Functions =
== ANYOF ==
Used to check if a value is matching a list of values

'''Example'''
<pre>
IF(ANYOF(storageArea.Name, "1", "2", "3"), "1, 2, or 3", "N/A")
</pre>

== COALESCE ==
Use the first value that isn't null.

'''Example'''
<pre>
COALESCE(product.name, storageArea.name)
</pre>
Will show the name of the storage area if there isn't any product in the storage area.

== IF ==
Match a single condition

'''Example'''
<pre>
IF(storageArea.status = storageAreaStatus.empty, "Empty", "Not empty")
</pre>

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'''
<pre>
IFS(
storageArea.fillLevel >= 50 and storageArea.fillLevel < 80, "#4caf05",
storageArea.fillLevel >= 80 and storageArea.fillLevel < 90, "#ff8800",
storageArea.fillLevel >= 90, "#ff1500",
"#b0b0b0"
)
</pre>

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'''
<pre>
MAX(1, 3, 2)
</pre>

will return 3

== MIN ==
Returns the MIN value of two or more values

'''Example'''
<pre>
MAX(42, 1, 100)
</pre>

will return 1

== NOT ==
Match a negative condition

'''Example'''
<pre>
IF(NOT(storageArea.status = storageAreaStatus.empty), "Not empty", "Empty")
</pre>

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

== ROUND ==
Round a value to specified number of digits

'''Example'''
<pre>
ROUND(123.456, 2)
</pre>

will return 123.46

== SWITCH ==
Handle multiple different matches for same condition. Possible to add a default value at the end.

'''Example'''
<pre>
SWITCH(storageArea.status, storageAreaStatus.inuse, "use", storageAreaStatus.empty, "empty", storageAreaStatus.full, "full", "n/a")
</pre>