CAML query on URL field （Stupid design）

Question

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><FieldRefName='URL'/><ValueType='URL'>/path/HR Policy.docx</Value></Eq></Where>

The URL field will have the display text also stored in it, so this is why you need the Contains node.

Answer 1

Friday, January 04, 2008 10:58 PM

M. Blumenthal

Magenic

(Partner)

30 Points

2

Sign In to Vote

I recently needed to see if an URL was in an SPList, and what I ended up doing was this:

Create a string variable to hold the tail end of the URL I am looking for. So if I am looking forhttp://server/managedpath/spwebOrSitecollectionname, I would put "/managedpath/spwebOrSitecollectionname" in the URLtail string variable.
Do my SPQuery to match against the URLTail instead of the URL, My CAML would look like this:

<Where>

<Value Type='URL'>/managedpath/spwebOrSitecollectionname</Value>

</BeginsWith>

</Where>

3. When I get my results back, convert each one to a string and see if it contains the FULL url (http://server/managedpath/spwebOrSitecollectionname).

Hope that helps!

--M.Blumentha

Answer 2

Friday, January 04, 2008 10:58 PM

M. Blumenthal

Magenic

(Partner)

30 Points

2

Sign In to Vote

I recently needed to see if an URL was in an SPList, and what I ended up doing was this:

Create a string variable to hold the tail end of the URL I am looking for. So if I am looking forhttp://server/managedpath/spwebOrSitecollectionname, I would put "/managedpath/spwebOrSitecollectionname" in the URLtail string variable.
Do my SPQuery to match against the URLTail instead of the URL, My CAML would look like this:

<Where>

<Value Type='URL'>/managedpath/spwebOrSitecollectionname</Value>

</BeginsWith>

</Where>

3. When I get my results back, convert each one to a string and see if it contains the FULL url (http://server/managedpath/spwebOrSitecollectionname).

Hope that helps!

--M.Blumenthal

score 0 · Accepted Answer

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><FieldRefName="FileRef"/><ValueType="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><FieldRefName="My_x0020_Document"/><ValueType="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><FieldRefName="My_x0020_Document"/><ValueType="URL">http://www.google.com</Value></Eq></Where>

@Kit Menke: I tried this as well (including yours) but same field not installed error <Where><Contains><FieldRef Name='URL'/><Value Type='URL'>/sites/SiteCol/subsite/Shared Documents/March Excel Report.xls</Value></Contains></Where>
@Mina Kumari: I've updated the answer to include a query for a document in a document library which I think is what you're after.
@Kit Menke: I am not getting that error with this code. I should see one file but no record is returned with the query. <Where><Eq><FieldRef Name="FileRef"/><Value Type="Url">sites/SiteCollection/SubSite/Site Documents/Excel Report.xls</Value></Eq></Where>
@Mina Kumari: What's the path of your document and did you put that into the query? Can you show the exact query you are trying?
<Where><Eq><FieldRef Name='FileRef'/><Value Type='Url'>sites/gatorade/Shared Documents 5/Sales Folder/Team_lists.txt</Value></Eq></Where> I put this in u2u tool. havnt tried in the winform app.

Technology	SharePoint 2007
Title	Cannot find anything with SPQuery CAML and GetItems when searching against URL field
Hint	When you want to look for items on the list or library searching with CAML by URL field you find zero items... although the URL is there. The typical CAML string is below: <Where> <BeginsWith> <FieldRef Name='URL'/> <Value Type='Text'>http://server/file.txt</Value>; </BeginsWith> </Where> Typical C# code to use SPQuery is: SPSite oSite = new SPSite("http://moss"); SPWeb oWeb = oSite.OpenWeb(); SPList oList = oWeb.GetListFromUrl("Lists/Links/AllItems.aspx"); SPQuery linksQuery = new SPQuery(); linksQuery.Query = this.txtCAML.Text; MessageBox.Show(oList.GetItems(linksQuery).Count.ToString()); There are few things you may wonder: 1) Should I use <Eq> or <BeginsWith> or <Contains> tag => in my case it turned out BeginsWith works fine (as URL is encoded as "URL, Title" in the field). 2) Shoold the value type be 'Text' or 'Url' => in my case it turned out both are equal. 3) Why the hell I cannot find my items (returns zero)? => it turns out the rules are as follows: a) IF you look for link that points to the same Sharepoint box THEN you should search with relative URL (so the caml value is just /file.txt and nothttp://server/file.txt. b) IF you look for link that points to any other box or even the same box with different port number (e.g. http://server:81/file.txt) THEN you should use full URL as in the CAML example above.

CAML query on URL field （Stupid design）

Answers

All Replies

Technology

Title

Hint

1 Answer

Querying for a Document in a Document Library

Querying for a document or list item with a URL field

公告