摘要:
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; 阅读全文