4D v17.4
entitySelection.count( )
- 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.count( )
The entitySelection.count( ) method returns the number of entities in the entity selection with a non-null value in attributePath.
Note: Only scalar values are taken into account. Object or collection type values are considered as null values.
An error is returned if:
- attributePath is a related attribute,
- attributePath is not found in the entity selection dataclass.
We want to find out the total number of employees for a company without counting any whose job title has not been specified:
C_OBJECT($sel)
C_REAL($count)
$sel:=ds.Employee.query("employer = :1";"Acme, Inc")
$count:=$sel.count("jobtitle")
entitySelection.average( )
entitySelection.distinct( )
entitySelection.length
entitySelection.sum( )
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)
