Knowledge: Example Select Query from Sysero Repeater XMLField
Back
Knowledge
Title*Example Select Query from Sysero Repeater XMLField
ManualReporting
Created19/09/2017
DetailSELECT ItemName, Repeater.Data.value('@Value','nvarchar(max)') FROM Claims Cross Apply XMLField1.nodes('//RepeaterData/Repeat/*[@DatabaseValue="TextField40"]') Repeater(Data)
Additional Manual Locations
Administration | Data Actions |