2

I wrote a java program that uses SharePoint's Lists web service.
Right now, this is my CAML Query :

<Query>
    <Where>
      <Contains>
         <FieldRef Name='FileDirRef'/><Value Type='Lookup'>SubFolder1</Value>
      </Contains>
    </Where>
</Query>

and this is my CAML Query Options :

<QueryOptions>
   <ViewAttributes Scope='RecursiveAll' />
   <OptimizeFor>FolderUrls</OptimizeFor>
</QueryOptions>

This is what my root folder looks like :

enter image description here

And my program returns all File3.txt, SubFolder2 and File4.txt
What should I do in order to only get the contents of SubFolder1 : File3.txt AND SubFolder2 ?

Also, Is there a way to place myself on a folder other than root ?

Ali
  • 325
  • 3
  • 6
  • 16
  • I think you need to check query.FolderServerRelativeUrl chk http://sharepoint.stackexchange.com/questions/59216/get-all-files-from-sub-folder-of-a-certain-content-type and http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010programming.aspx?ID=e37f16f3-44f5-48ad-962b-b0e6345ccc73 –  Sep 14 '16 at 17:38
  • Thanks @Neel , I've been looking down that path the hole night but there's no way of using FolderServerRelativeUrl under Java environment and you can't insert it directly into the CAML Query file either. – Ali Sep 15 '16 at 08:23
  • yes you are right FolderServerRelativeUrl is for sharepoint api only. –  Sep 15 '16 at 09:44

1 Answers1

2

I finally found the answer I was looking for thanks to this Blog.
I deleted the CAML Query settings :

<Query>
    <Where>
      <Contains>
         <FieldRef Name='FileDirRef'/><Value Type='Lookup'>SubFolder1</Value>
      </Contains>
    </Where>
</Query>

and added this line to my CAML Query Options file :

<Folder>http://MySharePointServer/Root/SubFolder1</Folder>

And changed the Scope to All instead of RecursiveAll so it would only bring items directly under SubFolder1.

So now this is my Final CAML Query Options File :

<QueryOptions>

    <Folder>http://MySharePointServer/Root/SubFolder1</Folder>  
    <IncludeMandatoryColumns>TRUE</IncludeMandatoryColumns>     
    <ViewAttributes Scope="All"/>   
    <DateInUtc>TRUE</DateInUtc>     
</QueryOptions>


PS : you have to specify the hole URL to the SubFile. you cannot use RelativeUrl for this option.

Ali
  • 325
  • 3
  • 6
  • 16