AsExprList
String functions AsExpr(ession)List
- AsExprList(string_dataitem)
- AsExprList(string_dataitem, relation)
- AsExprList(string_dataitem, separator) results in a string parameter with all values of string_dataitem, semicolon delimited and single quoted.
- AsExprList(string_dataitem, separator, relation) results in a string attribute with all values of string_dataitem, semicolon delimited and single quoted, grouped by the relation argument. The domain unit of the resulting attribute is the values unit of the relation.
- data item string_dataitem with string value type
- relation with value type of the group CanBeDomainUnit
The domain units of arguments string_dataitem and relation must match.
1. parameter<string> CityListParam := AsExprList(City/Name);
result = 'Groningen';'Delfzijl';'Winschoten';'Leeuwarden';'Dokkum';'Bolsward';'Emmen';'Assen';'Hoogeveen'
2. attribute<string> CityList (Region) := AsExprList(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
