minimum()

Signature

minimum() — returns any

Description

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.

Parameters

Name	Type	Required	Default	Description
property	string	yes	—	Name of the property to get the lowest value for (must be a property of a numeric data type).
where	string	yes	—	See documentation for findAll.
include	string	yes	—	See documentation for findAll.
parameterize	any	yes	true	See documentation for findAll.
ifNull	any	yes	—	See documentation for average.
includeSoftDeletes	boolean	yes	false	See documentation for findAll.
group	string	yes	—	See documentation for findAll.

Examples

// 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);