I have a multi-step form setup. For Retention policy of form data,I have set Keep Partial submission data for: ForeverKeep Finalized submission data for: ForeverWhen trying to export the data,for some reason I am not unable to get data for more than 30 days.With the below db query ,I am able to get the list of records that is dated a year back. For instance 2020 records.SELECT * FROM tblBigTableWHERE StoreName LIKE 'FormData_%'But when trying to get the data ,I cant find any & I know for a fact that there are records in database for the given date criteria.
Is there some configuration setting within forms that is missing or is the database query given above to get form submission details incorrect.Could someone help me understand the retention policy especially with Forever value.
For retention policy issue, there was a bug in EPiServer.Forms 4.30.1 package with the setting Default(forever). If you want to keep you data permanently on your Finalized forms, please change the value to Forever (not the default setting).Below is the blog link i found that describes the bug.https://www.umassmed.edu/it/services/web-services/episerver/blog/blog-posts/2021/03/forms-retention-policy/
This issue is now fixed in the latest EPiServer.Forms 4.30.3
Here is the release note reference from episerver