AsList
string-functions AsList
syntax
- asList(string_dataitem, separator)
- asList(string_dataitem, separator, relation)
definition
- asList(string_dataitem, separator) results in a string parameter with all values of string_dataitem, separated by the separator argument.
- asList(string_dataitem, separator, relation) results in a string attribute with all values of string_dataitem, separated by the separator argument, grouped by the relation argument. The domain-unit of the resulting attribute is the values-unit of the relation.
applies to
- data items string_dataitem and separator with string value-type
- relation with value type of the group CanBeDomainUnit
conditions
The domain units of arguments string_dataitem and relation must match.
example
1. parameter<string> CityListParam := AsList(City/Name, ';');
result = 'Groningen;Delfzijl;Winschoten;Leeuwarden;Dokkum;Bolsward;Emmen;Assen;Hoogeveen'
2. attribute<string> CityList (Region) := AsList(City/Name, ';', City/Region_rel);
| City/Name | City/Region_rel |
|---|---|
| ‘Groningen’ | 0 |
| ‘Delfzijl’ | 0 |
| ‘Winschoten’ | 0 |
| ‘Leeuwarden’ | 1 |
| ‘Dokkum’ | 1 |
| ‘Bolsward’ | 1 |
| ‘Emmen’ | 2 |
| ‘Assen’ | 2 |
| ‘Hoogeveen’ | 2 |
domain City, nr of rows = 9
| CityList |
|---|
| ‘Groningen;Delfzijl;Winschoten’ |
| ‘Leeuwarden;Dokkum;Bolsward’ |
| ‘Emmen;Assen;Hoogeveen’ |
domain Region, nr of rows = 3