XPath查询选择范围内的数据 [英] xpath query to select data in range

问题描述

<?xml version="1.0"?>
<AppXmlLogWritter>
  <LogData>
    <LogID>5678201301161640382919</LogID>
    <LogDateTime>20130114164038</LogDateTime>            
  </LogData>
  <LogData>
    <LogID>5678201301161640382920</LogID>
    <LogDateTime>20130115154040</LogDateTime>           
  </LogData>
  <LogData>
  <LogID>5678201301161640382921</LogID>
  <LogDateTime>20130116164042</LogDateTime>          
  </LogData>
</AppXmlLogWritter>

strXpathQuery = @"/AppXmlLogWritter/LogData[LogDateTime/text()>=[starts-with(. , '20130115') and LogDateTime/text()<=starts-with(. , '20130116')]";

我必须写XPath查询范围内选择logdata哪里LogDateTime与20130115至20130117开始
我想上面的查询，但无法获取数据

推荐答案

请试试这个：

/AppXmlLogWritter/LogData[substring(LogDateTime, 1, 8) >= 20130115 
                              and substring(LogDateTime, 1, 8) <= 20130116]

如果您要包括在选择20130117的项目，你会改变20130116值设置为20130117。

If you want to include 20130117 items in the selection, you would change the "20130116" value to "20130117".

这篇关于XPath查询选择范围内的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！