Back
minimum()
Calculates the minimum value for a given property.
Uses the SQL function MIN
.
If no records can be found to perform the calculation on you can use the ifNull
argument to decide what should be returned.
// Get the amount of the lowest salary for all employees
lowestSalary = model("employee").minimum("salary");
// Get the amount of the lowest salary for employees in a given department
lowestSalary = model("employee").minimum(property="salary", where="departmentId=#params.key#");
// Make sure a numeric amount is always returned, even when there were no records analyzed by the query
lowestSalary = model("employee").minimum(property="salary", where="salary BETWEEN #params.min# AND #params.max#", ifNull=0);
Copied!