AsItemList
string-functions AsItemList
syntax
- AsItemList(string_dataitem)
- AsItemList(string_dataitem, relation)
definition
- 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.
applies to
- data items string_dataitem with string value-type
- relation with value type of the group CanBeDomainUnit
conditions
The domain units of the arguments string_dataitem and relation must match.
example
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