BPM开发之123,数据库读取XML格式的字段内容
SELECT f.serialNumber AS SerialNumber2, CAST(f.fieldValues AS xml ).value('(/TYOT003/txt0201)[1]', 'varchar(20)') AS txt0201,
CAST(f.fieldValues AS xml ).value('(/TYOT003/txt0101)[1]', 'varchar(20)') AS txt0101,
CAST(f.fieldValues AS xml ).value('(/TYOT003/txt0202)[1]', 'varchar(20)') AS txt0202,
CAST(f.fieldValues AS xml ).value('(/TYOT003/txt0203)[1]', 'varchar(20)') AS txt0203, b.createdTime, b.endTime,
b.currentState, p.processDefinitionId, p.processInstanceName
FROM dbo.FormInstance AS f INNER JOIN
dbo.LocalRelevantData AS l ON f.OID = l.valueOID INNER JOIN
dbo.ProcessInstance AS p ON l.containerOID = p.contextOID INNER JOIN
dbo.BamProInstData AS b ON b.processInstanceOID = p.OID
WHERE (p.processDefinitionId = 'TYOT003')