Knowledge: Calculated field used in Maintenance App
Back
Knowledge
Title*Calculated field used in Maintenance App
ManualTips and Tricks
Created06/05/2022
Detail(
SELECT max(CONVERT(DATETIME,Repeater.Data.value('Data[@DatabaseValue="DateField3"][1]/@Value','nvarchar(max)'),103))
FROM (SELECT CAST(XMLField1 as xml) as xmlres) as conxml
CROSS APPLY conxml.xmlres.nodes('//RepeaterData/Repeat/Data[@BooleanValue="False"]/parent::Repeat')
Repeater(Data))
Additional Manual Locations