4D v19
entitySelection.distinct( )
- 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.distinct( )
The entitySelection.distinct( ) method returns a collection containing only distinct (different) values from the attributePath in the entity selection.
The returned collection is automatically sorted. Null values are not returned.
In the attributePath parameter, pass the entity attribute whose distinct values you want to get. Only scalar values (text, number, boolean, or date) can be handled. If the attributePath is an object attribute that contains values of different types, they are first grouped by type and sorted afterwards. Types are returned in the following order:
- booleans
- strings
- numbers
- dates
By default, a non-diacritical evaluation is performed. If you want the evaluation to be case sensitive or to differentiate accented characters, pass the dk diacritical constant in the option parameter.
An error is returned if:
- attributePath is a related attribute,
- attributePath is not found in the entity selection dataclass.
You want to get a collection containing a single element per country name:
C_COLLECTION($countries)
$countries:=ds.Employee.all().distinct("address.country")
Product: 4D
Theme: ORDA - EntitySelection
4D Language Reference ( 4D v19)
4D Language Reference ( 4D v19.1)
