CAML queries: how to filter folders from result set?

sharepoint caml
Marian Polacek picture Marian Polacek · Dec 2, 2008 · Viewed 50.2k times · Source

I'm using caml query to select all documents which were modified or added by user. Query runs recursively on all subsites of specified site collection.

Now problem is I can't get rid of folders which are also part of result set. For now I'm filtering them from result datatable. But I'm wondering: Is it possible to filter out folders from result set just by using caml?

Answer

Johan Leino picture Johan Leino · Sep 3, 2009

This CAML actually does the trick:

<Where>
    <Eq>
        <FieldRef Name='FSObjType' />
        <Value Type='Integer'>0</Value>
    </Eq>
</Where>

that will not give you any folders.

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