Jump to:
| Project: | Webform Report |
| Version: | 6.x-1.8 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I have installed the webform.module and webform_report.modules. (I'm going to call webform.module 'WF' from here forward so as not to confuse with Webform_Report.module) Both working great but with some 'Time' errors in the Webform Report. I've been submitting sample forms and then viewing the Webform Report and the Time category keeps recording the wrong time.
So, I thought of a better solution but still learning PHP and not quite sure what to do as far as coding goes.
***Solution*** (If only I could code well enough to do it)
In the WF Module there is already a report feature but it is very raw - nothing like Webform_Report.module. But the WF sorts the submission by taxonomy - if you view your submission results it numbers them in the left column #10, 11, and so on - and if you look at the address for each submission you will see /node/48/submission/10 and the next submission would be /node/48/submission/11
In order to get a Webform_Report that displays the most current submission at the top I was wanting to use this taxonomy feature to my benefit and the benefit of anyone else having the same problem.
Any suggestions would be greatly appreciated.
And if I ever figure this out on my own I will report back.
Thanks in advance!
Comments
#1
I hope you found the solution and will be posting it soon.
I would love to have Webform_Report display the most current submissions at the top.
I have used sorting by Date & Time, but that doesn't work!
#2
I've had this issue as well. I've come up with a couple of solutions
1) Got to the webform report page and sort the submissions as you like. Then bookmark the URL, eg
http://yourewebsite.co.nz/node/70/webform-results?sort=desc&order=%23&results=02) Hack the modules webform_report.inc file. Look for a line like...
array('data' => t('#'), 'field' => 'sid', 'sort' => 'asc'),...possibly at line 92, if you use the same version as me. Change 'asc' to 'desc'. You'll need to do more if you have more than one page of results. At the least you'll need to click on 'All results'. A better fix could come from something to do with $pager_count and $total_count.
#3
The recent version of Webform Report already has a very nice sorting option, but it doesn't work for some reason. e.g.: I am trying to have the latest submission at the top and no matter what I choose (as Date and Time with Asc or Desc) still sorts inconsistently.
I hope the sorting can be 'looked after' :)
#4
We should follow-up this sorting issue on the following topic:
http://drupal.org/node/327203
#5
Thank you for this report - I will be glad to help you resolve this issue.
I assume you are using the latest beta version of webform_report (BETA4). I'm afraid it took several attempts to get the sorting right (or so I thought :-( )
Please let me know which version of webform you are using - there are some changes in date/time field handling in the latest webform beta.
Is Submission Date the first column in Sort By under Report Criteria?
It would help if you could upload some screenshots illustrating your problem - especially Report Criteria and report views.
Thanks.
#6
Thanks Jim of the quick reply and a great module! please see the reply at this link:
http://drupal.org/node/327203#comment-3174414
#7