SharePoint Caml query Calculated Fields

最新推荐文章于 2021-12-16 16:56:00 发布

转载最新推荐文章于 2021-12-16 16:56:00 发布 · 858 阅读

文章标签：

#SharePoint #Camlquery #Calculated Fields

sharepoint 专栏收录该内容

6 篇文章

订阅专栏

本文详细解析了在SharePoint中使用CAML查询计算字段时遇到的值类型匹配问题，提供了正确的解决方法并展示了如何通过代码获取字段的实际值类型。

Do you have Problems with the SPSiteDataQuery (CAML) query of Sharepoint
computed Fields. You are running in an Error or recive an empty DataTable ?
Normaly you think your query must be correct because it looks exactly like this:

<Query>
 <Where>
   <Eq>
     <FieldRef Name='MyComputed' />
     <Value Type='Computed'>111</Value>
   </Eq>
 </Where>
</Query

Haha, yes my friend, you are realy not alone with this problem on the planet.

It seems to be the logical solution for the correct caml querry,
but the value type is saved in the format it is determined
in the Computet Field, So is the field of the Type Text, or Integer ?
Than the query must look like this:

<Query>
 <Where>
   <Eq>
     <FieldRef Name='MyComputed' />
     <Value Type='Number'>111</Value>
   </Eq>
 </Where>
</Query>

You can get the correct ValueType of the field with -> ((SPFieldCalculated)field).OutputType.ToString();

Please also note this. The Value defined for the coloumn has to match the ValueType that is expected with the formula !

For Example: The Result of (Column1+Column2) is interpreted by Sharepoint as Number
so the ValueType must be Number
For Example: The Result of =Concatanate([Column1][Column2]) is interpreted by Sharepoint as Text
so the ValueType must be Text