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