Unable to export form data beyond 30 days

Vote:
 

Hi,

I have a multi-step form setup. For Retention policy of form data,I have set 
Keep Partial submission data for: Forever
Keep Finalized submission data for: Forever
When 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 tblBigTable
WHERE 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.

Regards.

#254779
May 13, 2021 18:27
Vote:
 

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

https://world.episerver.com/documentation/Release-Notes/ReleaseNote/?releaseNoteId=AFORM-2804

Regards.

#257121
Jun 25, 2021 13:25
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.