LEASTedit
Returns the minimum value from many columns. This is similar to MV_MIN
except it’s intended to run on multiple columns at once.
ROW a = 10, b = 20 | EVAL l = LEAST(a, b)
| a:integer | b:integer | l:integer |
|---|---|---|
10 |
20 |
10 |
When run on keyword or text fields, this’ll return the first string
in alphabetical order. When run on boolean columns this will return
false if any values are false.
Supported types:
| first | rest… | result |
|---|---|---|
boolean |
boolean |
boolean |
integer |
integer |
integer |
keyword |
keyword |
keyword |
long |
long |
long |
text |
text |
text |