Tuesday, March 24, 2015

Filter list view webpart using querystring parameters for date

Querystring paramters can be added to a XmlListViewWebpart and the data can be filtered based on them, however when using date parameters, the format of date in querystring is often confusing. The correct date format is yyyy-MM-dd. More details in the following two blogs

https://stackoverflow.com/questions/1655664/sharepoint-list-view-datetime-in-the-query-string/29235326#29235326

https://social.technet.microsoft.com/Forums/en-US/92271aa4-6582-4ea5-a10f-deaf02d2b62c/filtering-the-list-view-by-passing-date-parameters-using-sharepoint-desginer-2010?forum=sharepointcustomizationprevious


There is also a custom webpart available on codeproject which creates a custom menu button to export only filtered list view webpart data to excel

http://www.codeproject.com/Articles/400720/SharePoint-2010-Export-Selected-Items-to-Excel

No comments:

c# httpclient The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch

 If we get this error while trying to get http reponse using HttpClient object, it could mean that certificate validation fails for the remo...