4D v19
entitySelection.max( )
- 4D Language Reference
-
- ORDA - EntitySelection
-
- entitySelection.{attributeName}
- entitySelection.length
- entitySelection.queryPath
- entitySelection.queryPlan
- entitySelection[index]
- entitySelection.or( )
- entitySelection.orderBy( )
- entitySelection.drop( )
- entitySelection.query( )
- entitySelection.add( )
- entitySelection.isOrdered( )
- entitySelection.minus( )
- entitySelection.first( )
- entitySelection.last( )
- entitySelection.toCollection( )
- entitySelection.contains( )
- entitySelection.and( )
- entitySelection.sum( )
- entitySelection.count( )
- entitySelection.min( )
- entitySelection.max( )
- entitySelection.slice( )
- entitySelection.distinct( )
- entitySelection.average( )
- entitySelection.getDataClass( )
- entitySelection.orderByFormula( )
- entitySelection.refresh( )
- entitySelection.extract( )
- entitySelection.copy( )
- entitySelection.isAlterable( )
- Create entity selection
- USE ENTITY SELECTION
entitySelection.max( )
The entitySelection.max( ) method returns the highest (or maximum) value among all the values of attributePath in the entity selection. It actually returns the value of the last entity of the entity selection as it would be sorted in ascending order using the entitySelection.orderBy( ) method.
If you pass in attributePath a path to an object attribute containing different types of values, the entitySelection.max( ) method will return the maximum value within the first scalar type in the default 4D type list order (see collection.sort( ) description).
entitySelection.max( ) returns undefined if the entity selection is empty or attributePath is not found in the object attribute.
An error is returned if:
- attributePath is a related attribute,
- attributePath designates an attribute that does not exist in the entity selection dataclass.
We want to find the highest salary among all the female employees:
C_OBJECT($sel)
C_REAL($maxSalary)
$sel:=ds.Employee.query("gender = :1";"female")
$maxSalary:=$sel.max("salary")
Product: 4D
Theme: ORDA - EntitySelection
4D Language Reference ( 4D v19)
4D Language Reference ( 4D v19.1)
