Sharepoint CAML query to search folder on ID field

Question

Using CAML in WSS3, I am trying to search for a folder by the folder ID field. This results in 'undefined' when searching the 'Folder' content type but works fine searching for a regular item.

Here is a snippet of my code:

<Query><Where><Eq><FieldRef Name='ID'/><Value type='Integer'>"+folderIDtoFind+"</Value></Eq></Where></Query>
...
<QueryOptions><ViewAttributes Scope='Recursive' /></QueryOptions>

Any suggestions for how I can find folders by their id's?

score 3 · Accepted Answer · edited May 23 '17 at 12:26

3

Try

<Query><Where><Eq><FieldRef Name='ID'/><Value type='Counter'>"+folderIDtoFind+"</Value></Eq></Where></Query>

Also, grab a copy of A CAML builder tool...

edited May 23 '17 at 12:26

Community

1
1

answered Aug 24 '11 at 21:42

Nat

14,175
5
41
64

Wow that was an easy one! Switching Integer to Counter did the trick. Thanks. – JasonD Aug 25 '11 at 13:12
U2U has taken down CAML Builder. See this question for options still available: http://stackoverflow.com/questions/16420835/u2u-caml-query-builder-no-longer-available – Dan Is Fiddling By Firelight Jun 10 '13 at 20:45
3

I had a problem with type='Counter', it has to be uppercase: Type='Counter' – JDeuker Mar 05 '15 at 10:56

Sharepoint CAML query to search folder on ID field

1 Answers1