Knowledge: Combine repeater values into a single comma seperated string
Back
Knowledge
Title*Combine repeater values into a single comma seperated string
ManualTips and Tricks
Created10/01/2023
DetailObviously below change XMLFieldx and TextFieldx for correct ID's. Below goes in the usual field select.
Stuff(XMLFieldx.query('for $step in //Repeat/Data[@DatabaseValue="TextFieldx"]/@Value return concat(", ", string($step))').value('.', 'nvarchar(max)'),1, 2, '') as 'Conflicts'
Note some functions like Stuff cannot go in core code due to SQL backwards compatability, but can be used in reports where server supports.
Additional Manual Locations