2

Is it possible to filter WFFM reports by date range in Sitecore v8.2 ?

Current reports are either taking a long time to run or are timing out.

Users have requested the ability to add a date filter to limit the number of records being returned and to reduce the wait time for reports to be generated.

Improve this question

1 Answer 1

Reset to default
1

One of the reason for slow response or timeout of the WFFM reports are db indexes.

Could you please try the following on WFFM database of your instance:

1) add an additional index for the FormId to the FieldData table:

USE [Sitecore_Wffm]
GO
CREATE NONCLUSTERED INDEX [FormId_FieldData]
ON [dbo].[FieldData] ([FormId])
GO

2) Rebuild both [PK_FieldData] and [PK_FormData] 3) Make sure that Avg. Fragmentation is within 5% for all indexes.

To check the Avg. Fragmentation, you can use the "Index Physical Statistics" from Standard Report.

enter image description here

enter image description here

Once the Avg. Fragmentation is within 5%, try to generate the reports again which should be faster.

Improve this answer
3
  • Thanks for the comment. I am currently looking at rebuilding the indexes but specifically wanted to find a way to restrict wffm reports by date.
    – Ged
    Commented Sep 3, 2018 at 9:00
  • You can look at the sitecore.stackexchange.com/questions/11615/…. This is not exactly what you need but it gives an idea from where you can start working to get the date filter functionality. Reg indexes, if it improves the performance of the reporting then do update the status as it could help others.
    – Waqar Haider
    Commented Sep 3, 2018 at 9:12
  • I hadn't thought of taking that approach. Thanks!
    – Ged
    Commented Sep 3, 2018 at 9:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.