leim

摘要： 1. 对于Lookup Field，Caml 语句如下：<Query><Where> <Contains> <FieldRef Name="AlertLocation" LookupId="TRUE" /> <Value Type="text">1</Value> </Contains></Where></Query> “1”代表 ID， Lookup List ItemID2. 如果没有Filter出来， 可以考虑把Name= 阅读全文

摘要： When lookup fields are created, sharepoint stores them asID;#Value format in related list.for e.g.in list “Contacts” there is column called “Country”.There is item in contact with value “India” assigned in Country, having item ID=10.Now for another list “List2″ when column “Country” is stored as Loo 阅读全文

摘要： Even though Microsoft encourages using LINQ in SharePoint 2010, they introduced some new CAML Query schema elements. They are· IN· INCLUDES· NOT INCLUDESIN:This is something work as same as what we see in SQL Query. We can provide a collection of Items to filter. Previously in SharePo 阅读全文

摘要： 1. http://msdn.microsoft.com/en-us/library/bb862071.aspx;2. http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx; 阅读全文