4D v17.4
entitySelection.min( )
- 4D Language Reference
-
- ORDA - EntitySelection
-
- entitySelection.{attributeName}New
- entitySelection.lengthNew
- entitySelection.queryPathNew
- entitySelection.queryPlanNew
- entitySelection[index]New
- entitySelection.or( )New
- entitySelection.orderBy( )New
- entitySelection.drop( )New
- entitySelection.query( )New
- entitySelection.add( )New
- entitySelection.isOrdered( )New
- entitySelection.minus( )New
- entitySelection.first( )New
- entitySelection.last( )New
- entitySelection.toCollection( )New
- entitySelection.contains( )New
- entitySelection.and( )New
- entitySelection.sum( )New
- entitySelection.count( )New
- entitySelection.min( )New
- entitySelection.max( )New
- entitySelection.slice( )New
- entitySelection.distinct( )New
- entitySelection.average( )New
- Create entity selectionNew
- USE ENTITY SELECTIONNew
entitySelection.min( )
The entitySelection.min( ) method returns the lowest (or minimum) value among all the values of attributePath in the entity selection. It actually returns the first 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.min( ) method will return the minimum value within the first scalar value type in the type list order (see collection.sort( ) description). In this case, if attributePath does not exist in the object, entitySelection.min( ) returns null.
If the entity selection is empty, entitySelection.min( ) returns null.
An error is returned if:
- attributePath is a related attribute,
- attributePath is not found in the entity selection dataclass.
In this example, we want to find the lowest salary among all the female employees:
C_OBJECT($sel)
C_REAL($minSalary)
$sel:=ds.Employee.query("gender = :1";"female")
$minSalary:=$sel.min("salary")
Product: 4D
Theme: ORDA - EntitySelection
4D Language Reference ( 4D v17)
4D Language Reference ( 4D v17.1)
4D Language Reference ( 4D v17.2)
4D Language Reference ( 4D v17.3)
4D Language Reference ( 4D v17.4)
