Model Class Statistics Functions any model
Calculates the minimum value for a given property.
Uses the SQL function
If no records can be found to perform the calculation on you can use the
ifNull argument to decide what should be returned.
|property||string||Yes||Name of the property to get the lowest value for (must be a property of a numeric data type).|
|where||string||No||Maps to the
|include||string||No||Associations that should be included in the query using
|ifNull||any||No||The value returned if no records are found. Common usage is to set this to
|group||string||No||Maps to the
// 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);