.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Create CAML for listing docs from a document library which has subfolders as well.

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint
Hi imagine a doc library in sharepoint holding PDF's called DocA.
DocA has subfolders e.g DocA\sub1, DocA\sub2
I am writing a CAML query to extract PDF's which were created older than 7 days.
My issues is i cant get the PDf's items in CAML query and it just shows the folder only.

Here is my code.

SPSite site = new SPSite(Site);
SPWeb web = site.OpenWeb();
SPList list = web.Lists["DocA"];
string querystring = "<Leq>" +
                     "<FieldRef Name='Created' />" +
                     "<Value Type='DateTime'><Today /></Value>" +

SPQuery query = new SPQuery();
query.RecurrenceOrderBy = true;

query.Query = querystring;
DataTable table = list.GetItems(query).GetDataTable();
return table;

View Complete Post

More Related Resource Links

Listing documents in Folders and subfolders in a Dataview of Document Library

My dataview is pointed to a Document Library. I noitced files in folders and subfolders don't list - only the folders themselves.  Is there any way to list files in a particular folder or all files in all folders? What I'm trying to do is tie a folder to entries in a custom list. I'd like a folder for every ID in that custom list. When I open the Dispform for the ID, I'd like a dataview or some other webpart to dynamically to show related files (all which would ofcourse just be in their respective folder). I'm thinking it's just a matter of passing the ID querystring to a condition in the Dataview or Webpart. It would also have to be a folder as I need to allow same file names to be uploaded.   Thanks.  

SPD workflow status show "starting" when I create a document from the library !!. and hangs

I have a document library in MOSS 2007. Have created a WF and that starts "autmatically when new item created" In the document library I have created couple of column those are mandatory (required columns) and user has to fill those column while uploading a document as well creating a document from library. WF has ran and completed succefully  when I use "upload" option to load a document.  As you are aware, when we "upload" a document, we will have to fill all "required columns" and the click "check in" command button.  After I do all this, document get loaded and WD ran succesfully. However, the WF is not running when I create a document (.docx) from this library (using "new" button) !!.  I have filled all required field in the document information panel . After save & exit from WORD application, I can see WF status as "starting". But, it never started and completed.  So I did following and found WF worked !! a) After creating document (.docx) using "new" option I found WF status "starting"!. So,  I did "Check-out and Check-in" manually from document library. After doing this,  WF ran and status has been changed as "completed" b) In SPD, I change workflow start option from "Automatic" to "Manually start".&nb

Unable to create columns in document library after applying custom master page to site

Hi, I have applied a custom master page to a site.There is a document library in it. I am unable to add columns in it or change the default view.Nothing happens when I click on OK butoon after making my changes. However the columns are created/default view is changed when I apply the default master page. Guess I am missing some TagPrefix or sharepoint control on master page.I had solved this problem earlier in this way but don't remeber it now. Can anyone help?

create a custom "newform.aspx" for document library using sharepoint designer and web services


Hi All,

I need to change the look and feel of "NewForm.aspx" for my Sharepoint 2007 Document Library. But the constraints are

1. I cant use C# coding. No Visual Studio.

2. Not allowed change anything in the farm level. e.g. cant install features/webparts fo this.

3. Can only use JavaScript, JQuerry and Sharepoint Designer 2007.

I came across some suggestions that we can create a custom page in Javascript/JQuery. Which will take all input data and insert new items in list/doc library using some XML services.

Please help me, I dont know if this is really possible. Let me know if any alternative is possible.

TreeView not listing in certain document library in SP2007


Hi All,

        We are not able to view treeview for certain document libraries in SP2007 site but certain document libraries we able to view treeview ?

How do I create an Upload.aspx link on the front page of my document library without the subsequent


I need to create an Upload.aspx link on the front page of my document library, rather than rely on the + Add Document link at the bottom of the list.

When I copy the URL of the Add Document link to my page or as a quick link it uploads the file, brings up the metadata form, but then asks the user to save the file on save.

Clicking on the + Add Document link does a clean upload without the reuest to save the file?

The link I create has the format "_Layouts/Upload.aspx?List={ABC123}&RootFolder=tFolder="

Is there some parameter to Upload.aspx? that I need to add?

Error opening Office Open XML file when using SD workflow to create item in document library.


I have a Sharepoint document library that is using a word template with xml mapping (Word-Sharepoint).

I have a workflow created in Sharepoint designer that Creates an item in this document library with select data from a form library on the same site. 

It appears to create the entry in the document library correctly, it is showing the copied data from the form library and the correct default data in the columns specific to the document library. The explorer view shows the filename.docx files.

I am able to edit the data using the datasheet view, however it will not open the word document.

The error message reads "The Office Open file <filename> cannot be opened because there are problems with the contents." If I click on the details button it states "No error detail available".

Any ideas?

Upload a File to a SharePoint Document Library - Part I

The following helper class demonstrates a few techniques that allow documents to be uploaded to a SharePoint document library programmatically without using the API or a custom web service. You don't need to specify a document library name, and it will create any folders specified in the URL as required. File meta data will be updated if any properties are passed.

Toolbox: Create Help Docs, Automate Builds, and More


This month we look at creating documentation, guarding intellectual property, automating the build process, and a book on writing software.

Scott Mitchell

MSDN Magazine September 2006

IE closing when user try to access the document library

<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> IE closing (crashing) when user try to access the document library in share point site.  here we are using WSS2.0.  this problem for not accursed all the users , this problem happening on some users. 

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



Can I open the "new" menu in a SharePoint Document Library using Dragon NaturallySpeaking?


When a user, who uses Dragon NaturallySpeaking, says "new" when viewing a Document Library the default content type is selected and the associated application (e.g. Microsoft Word) is launched. This scenario is okay for Content Type selection since the Microsoft Office applications will prompt for the metadata once the file is saved.

If the user needs to create new folders in the Document Library however they need to expand the "new" dropdown menu.

What is the best way for someone using Dragon NaturallySpeaking to expand the "new" menu for a Document Library in SharePoint?

Cannot copy document to other library

When I try to send a document to another SharePoint library (Send To>Other Location) I am receiving a blank message box.  Does anyone have an idea what the empty message box is about or why this error is occurring?  Thank you!

Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

File Attachments from info-path forms to Sharepoint document library


Hi Experts,

How to upload file attachements from info-path forms to Sharepoint document library?

I need to add attachement from local-PC/Any User to Sharepoint Document Library.


Any help please?? Appreciated




Creating a custom column with a link to document (other than the name field) in document library



I have a document library with the standard name column linking to the document. However, we'd like to create a custom field and have that link to the document (and edit item menu).

How is this best accomplished?

Thanks in advance!


Error adding a document library to a site



I am receiving the error "Cannot complete this action.  Please try again"  when trying to add a document library to one of the sites.  This is Sharepoint 2007 SP1.  I seem to be able to do it thru designer but not the web interface.

Does anyone know how to fix this?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend