我可以解析出9531这样的值,因为它们包含在标记中 StatusValue
. 但我该怎么做呢 DateTime
, FromAppId
以及 MessageId
?
<PhoneCallEvent DateTime="2018-09-10T12:51:33.743-04:00"
FromAppId="200002"
MessageId="3407802">
<LoanNumber>307375</LoanNumber>
<StatusValue>9531</StatusValue>
<StatusUserCommonID>2561550</StatusUserCommonID>
<CallDirection>Inbound</CallDirection>
<CallStartTime>2018-09-10T12:49:37.000-04:00</CallStartTime>
<CallEndTime>2018-09-10T12:51:28.000-04:00</CallEndTime>
<VectorDirectoryNumber/>
</PhoneCallEvent>
1条答案
按热度按时间eqfvzcg81#
配置单元具有xpath函数:
SELECT xpath (
xml\u字符串,
xpath) FROM src LIMIT 1
SELECT xpath_string (
xml\u字符串,
xpath) FROM src LIMIT 1
SELECT xpath_
类型(
xml\u字符串,
xpath) FROM src LIMIT 1
例如,你可以使用xpath_string
使用xpath,选择
DateTime
属性值。