I am programmatically adding a list on the site page.
The list is being added however the query that I am using for the view has no effect, Please find below the code I am using:
using (SPLimitedWebPartManager wpManager = web.GetLimitedWebPartManager("SitePages/" + pageName, PersonalizationScope.Shared))
{
SPList list = web.Lists["List"];
XsltListViewWebPart wp = new XsltListViewWebPart();
wp.ListName = list.ID.ToString().ToUpper();
wp.ViewGuid = String.Empty;
wpManager.AddWebPart(wp, "Rich Content", 0);
wpManager.SaveChanges(wp);
list.Update();
foreach (System.Web.UI.WebControls.WebParts.WebPart webPart in wpManager.WebParts)
{
if (webPart is ListViewWebPart && webPart.Title.Equals("My webpart"))
{
var listViewWebpart = webPart as ListViewWebPart;
var view = list.Views[new Guid(listViewWebpart.ViewGuid)];
webPart.Dispose();
view.Query = @"<Where><Leq><FieldRef Name='DateTime'/><Value Type='DateTime'><Today /></Value></Leq></Where><OrderBy ><FieldRef Name='Modified' Ascending='false' /></OrderBy>";
view.RowLimit = 1;
view.Update();
}
}
}
Please let me know if I am missing out something. Any suggestion will be of great help. Thanks in advance.
Regards, Ankita