开发者

CAML Query BeginsWith Numeric Issue

In the following CAML query I reference 0 in the the line below.

<Value Type='Text'>0</Value>

This doesn't work even when the value is 0 bu twhen it is A it does work (I have entries in for both A and 0). I am unsure why numeric values are not getting picked up.

Any help would be appreciated.

<Query>
      <Where>
        <And>
          <Eq>
            <FieldRef Name='TCategories' />
            <Value Type='Text'>Abbreviations</Value>
          </Eq>
          <BeginsWith>
            <FieldRef Name='FirstCharacter' />
            <Va开发者_开发技巧lue Type='Text'>0</Value>
          </BeginsWith>
        </And>
      </Where>
</Query>


i do have a similar query like this

CAML Query BeginsWith Numeric Issue

which is actually working fine for me.

Make sure that the columns in your query "TCategories" and "FirstCharacter" are of Text type.

Thanks,
-Codename "Santosh"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜