I am working on Sitecore 8.2 rev.161221 and Web Forms for Marketers 8.2 rev. 161129.
When I'm exporting a form data into excel using "Export form data to Excel" option inside Form Report it is giving me only 2-3 days data and not entire data from the beginning.
During wffm installation i run the script WFFM_Analytics.sql and i can see all the data of the form in reporting database WFFM tables but unable to view and export this entire from data inside Form Reports.
formsDataProvider is set to "analyticsFormsDataProvider" inside Sitecore.WFFM.Dependencies.config
Why does it export only few data and not the entire data ?
Is there a way to get entire data of a form from SQL WFFM tables to the excel with "Export form data to Excel" option inside Form Report ?
Is there any time period setting to export form data of that time period only?
Is there a SQL query to just pass the formID parameter and will give me the entire data in correct organised way having form fields as columns and data as rows inside database ?