此查询返回的值小于1000.它应该只返回1000到1100之间的值.为什么会这样？
// results / Building [1 = 1和((Vacancy / sqft> 1000)和(Vacancy / sqft< 1100))] 查询将返回以下建筑物,其空位小于1000平方英尺,大于1100平方英尺：
<Building> <Vacancy><sqft>900</sqft></Vacancy> <Vacancy><sqft>1000</sqft></Vacancy> <Vacancy><sqft>2000</sqft></Vacancy> <Vacancy><sqft>500</sqft></Vacancy> </Building>
为什么它包含在结果中？
样本数据：
<results>
<Building><!--Shouldn't be selected.--></Building>
<Building><!--Should be selected-->
<Vacancy><sqft>1050</sqft></Vacancy>
</Building>
<Building><!--Should be selected-->
<Vacancy><sqft>1025</sqft></Vacancy>
<Vacancy><sqft>1075</sqft></Vacancy>
</Building>
<Building><!--Shouldn't be selected-->
<Vacancy><sqft>10</sqft></Vacancy>
<Vacancy><sqft>50</sqft></Vacancy>
</Building>
<Building><!--Should be selected.-->
<Vacancy><sqft>1050</sqft></Vacancy>
<Vacancy><sqft>2000</sqft></Vacancy>
</Building>
<Building><!--Should be selected.-->
<Vacancy><sqft>900</sqft></Vacancy>
<Vacancy><sqft>1040</sqft></Vacancy>
</Building>
<Building><!--Shouldn't be selected-->
<Vacancy><sqft>10500</sqft></Vacancy>
</Building>
<Building><!--Shouldn't be selected-->
<Vacancy><sqft>900</sqft></Vacancy>
<Vacancy><sqft>1000</sqft></Vacancy>
<Vacancy><sqft>2000</sqft></Vacancy>
<Vacancy><sqft>500</sqft></Vacancy>
</Building>
</results>
谢谢.
解决方法
您是否还需要匹配超出标准的平方英尺建筑物,但至少有一平方英尺在1000-1100之间
<Building>Should this be selected too?
<Vacancy><sqft>1000</sqft></Vacancy>
<Vacancy><sqft>1050</sqft></Vacancy>
<Vacancy><sqft>2000</sqft></Vacancy>
</Building>
如果是,则使用XPath表达式
/results/Building[Vacancy/sqft[. > 1000 and 1100 > . ] or not(Vacancy)]
它还选择没有< Vacancy>的建筑物.元素(根据要求).
