MIN
Use this function to determine the minimum value of a list or collection.
The MIN function has two syntax forms: the collection form and the list form. You can use the collection form to determine the minimum value of all occurrences of an attribute. The list form is used to determine the minimum value of a set of different attributes.
1. Collection form syntax | Code Block |
|---|
MIN ( attribute ) |
Input
2. List form syntax | Code Block |
|---|
MIN ( [ value1 , value2 , ... ] ) |
Input[ value1 , value2 , … ] - A list of attributes, expressions or fixed values of any type of integer, number, date or string. Use the square brackets to indicate that the arguments form a list of values.
Examples Suppose the following domain model.
| Entity.attribute | Value | Multivalued relation | Entity.attribute | Values |
|---|
Residence.appraisalValue Residence.askingPrice Residence.mortgage | € 140000 € 150000 € 142000 | hasBiddings | Bidding.amount | € 132000 € 139000 € 137500 |
| Goal | Expression | Result | Type |
|---|
| To determine the smallest amount within the appraisal value, the asking price and the mortgage | MIN ( [ Residence.appraisalValue , Residence.askingPrice , Residence.mortgage ] ) | € 140000 | Currency | | To determine the lowest bidding on the current residence | MIN ( Residence.hasBiddings.amount ) | € 132000 | Currency |
Example with strings | Expression | Result |
|---|
| MIN( ["after", "action"] ) | "action" |
|