小花喵 老牛亦知昭光贵,不用扬鞭自奋蹄。

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')


作者:admin 分类:未分类 浏览:1639 评论:0
留言列表
发表评论
来宾的头像