SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need a content query web part that returns me the last 10 modified or added documents into any document library on that specific website.

How can I add the rowlimit by code?

ContentByQueryWebPart cqwp = new ContentByQueryWebPart();
                                cqwp.ContentTypeBeginsWithId = "0x0101008E49C3D400044AB3A2F1DD14073E74F6001D06D12572244BE3A11AAEE3ED60F576";
                                cqwp.WebUrl = SPContext.Current.Web.ServerRelativeUrl;
                                cqwp.Title = "Last Updated Documents";                                
                                string query = @"<Where> "+
                                                "<OrderBy> "+
                                                    "<FieldRef Name='Modified'  Ascending='FALSE'/> "+
                                cqwp.QueryOverride = query;
                                cqwp.ListsOverride =  "<Lists ServerTemplate='101'></Lists>";
                                cqwp.WebsOverride = "<Webs Recursive='False' />";
                                cqwp.ViewFieldsOverride = @"<ViewFields> " +
                                                                "<FieldRef Name='Type' Nullable='True' Type='Text'/> " +
                                                                "<FieldRef Name='Name' Nullable='True' Type='Text'/> " +
                                                                "<FieldRef Name='ContentType' Nullable='True' Type='Text'/> " +
                                                                "<FieldRef Name='Modified' Nullable='True' Type='DateTime'/> " +
                                                                "<FieldRef Name='Modified By' Nullable='True' Type='Text'/> " + 

                                mgrPageManager.AddWebPart(cqwp, "Footer", 0);
share|improve this question
up vote 1 down vote accepted

You can set the RowLimit property of your SPQuery object because the is in the schema definition of a view not on the <Query>.

share|improve this answer
there is no such SPQuery object on a content query webpart, there is only queryoverrides which is a string – Esteban V Jun 10 '13 at 10:08
what about… – Salvatore Di Fazio Jun 10 '13 at 10:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.