CAML > get an item by it's URL

sharepoint caml
Mina Kumari picture Mina Kumari · Mar 14, 2011 · Viewed 19.8k times · Source

Should this CAML be working. (I tried it with u2u and it does not display the URL column.) I get this error. {System.ApplicationException} = {"One or more field types are not installed properly. Go to the list settings page to delete these fields."}

<Where>
 <Eq>
     <FieldRef Name='URL' />
     <Value Type='URL'>/path/HR Policy.docx</Value>
 </Eq>
</Where>

Answer

Kit Menke picture Kit Menke · Mar 14, 2011

Querying for a Document in a Document Library

Looks like you are trying to find a document in a document library using CAML. You can do this by using the hidden column named "FileRef":

<Where><Eq><FieldRef Name="FileRef"/><Value Type="Url">sites/SiteCollection/SubSite/Site Documents/Excel Report.xls</Value></Eq></Where>

Note: Do not include the server name or beginning /.

Querying for a document or list item with a URL field

The following examples assuming you have a list or library setup with a URL column named "My Document".

The link is to a document that is hosted on the sharepoint server (do not need server name):

<Where><Eq><FieldRef Name="My_x0020_Document"/><Value Type="URL">/sites/subsite/Site%20Documents/Excel%20Report.xls</Value></Eq></Where>

The link is an absolute URL to something not on the server... for example http://www.google.com:

<Where><Eq><FieldRef Name="My_x0020_Document"/><Value Type="URL">http://www.google.com</Value></Eq></Where>

Related questions

CAML query with nested ANDs and ORs for multiple fields

I am working on proof-of-concept code to dynamically generate CAML based on keywords provided to a highly-specific search web service that I am writing. I am not using the SharePoint-provided search web service for this proof. I have done so …

Read More
One or more field types are not installed properly. Go to the list settings page to delete these fields

CamlQuery query = new CamlQuery(); query.ViewXml = @"<View>" + "<Query>" + "<Where><Eq><FieldRef Name='Name' /><Value Type='Text'>" + fileName + "</Value>" + "</Eq>" + "</Where>" + "</Query&…

Read More
Getting list item field values from a SP List using Client Object Model

What is the optimal way to get a list items and their properties from a SP list using Client object model? Here is the code I'm using. string server = "http://localhost"; ClientContext context = new ClientContext(server); Web web = context.Web; …

Read More