So my problem was after creating a webform report I wasn't able to filter the report data by a date value. So below you will find the patch files that will add this functionality into the module. I will be more then happy to help if you need any more information.
NOTE: Dependent on date module (http://drupal.org/project/date) Plug-ins: Date API & Date Popup.
Thanks!
| Comment | File | Size | Author |
|---|---|---|---|
| #11 | 867908.patch | 3.12 KB | jimbullington |
| Screen shot 2010-07-28 at 3.28.28 PM.png | 42.62 KB | droath | |
| Screen shot 2010-07-28 at 3.29.01 PM.png | 52.68 KB | droath | |
| webform_report_6.x-1.11_date_range_feature_module.patch | 6.02 KB | droath | |
| webform_report_6.x-1.11_date_range_feature_inc.patch | 2.7 KB | droath |
Comments
Comment #1
droath commentedComment #2
jimbullington commentedThanks for the patch - it looks good. A couple of things:
Comment #3
rsacchi commentedThere is a way to implement this wonderful patch in the 6.x-2.0 version?
Thanks
Comment #4
droath commentedGood Idea...
I was thinking about doing both these implementations initially, but ran out of time in the long run. I will look into making both these changes here soon.
Thanks!
Comment #5
droath commentedHi rsacchi,
After I look into getting the above implementations in 6.x.1.11, I will look into writing a patch for 6.x.2.0.
Thanks!
Comment #6
rsacchi commentedSounds great, the version 2.0 has many new features and improvements http://drupal.org/node/826512 .
Thank you so much for this assistance.
Comment #7
rsacchi commentedAny progress on this feature ?
Comment #8
droath commentedNot yet! Sorry! I'm in bit of a time crunch with a couple other projects that I'm working on. I hope to have this feature added to version 6.x-2.0-beta4 soon. I don't think I will be coding anything for 6.x.1.11 due to webform 3.0 releasing. Does anyone know if 6.x-2.0-beta4 is stable enough for production yet? I know the developer suggested not to install version 6.x-2.0-beta4 on a production server as of 6/13/2010, has this changed?
Comment #9
MBroberg commentedWith the changes listed in
drupal.org/node/832690#comment-3383662
I actually have Beta4 running on a production site. I have not tested the patch in #12, but it works and doesn't break anything else. I have a ton of modules running on the site and 400 submissions that are showing up in reports very well.
Comment #10
jimbullington commentedThanks for the feedback - I'm thinking I will need a Beta5 on order to address these issues:
#299414: Add search field to reports
#327203: Ability to determine column display order
#832690: Unknown column 'columns' in 'field list' query error (Waiting for patch feedback)
#846528: Filter field in the main report page
#865754: patch to "select" type column to show value instead of key (Need to test patch)
#867908: Date Range Report Filter (Waiting for patch revision)
Maybe after that we will have a descent feature set and the module will be stable enough for release. I'll try to get this done ASAP.
Comment #11
jimbullington commentedA patch for 6.x-2.0-BETA is attached.
In order to filter by date range, add two filters, one greater than (or greater than or equal - added here), and one less than (or less than or equal). Special processing has been added to properly compare dates and times.
Comment #12
rsacchi commentedJim, thank you, this is a very useful feature, but not represents the first patch provided by droath for webform 6.x-1.11, which one the end user could filter the reports by date.
I apreciate your help !
Comment #13
bomarmonk commentedI would also like to see the original implementation of date range filter (the top patch here). Since this can be applied by the end user of the report, it prevents a report user from having to make a new report every time the user wants to filter to a certain date criteria (this is very elegant from a UI perspective). The Date API is not an issue for me, and I'm not sure it would be that big of a deal to make this reports module dependent on the very robust Date API by KarenS for the sake of handling date functionality (just playing devil's advocate here).
Comment #14
meordonez commentedI am trying to install this patch to my webform_report module from linux and but I have the following errors:
$ patch -p0 < webform_report_6.x-1.11_date_range_feature_inc.patch
patching file webform_report.inc
Hunk #1 FAILED at 54.
Hunk #2 FAILED at 81.
Hunk #3 FAILED at 224.
Hunk #4 FAILED at 244.
4 out of 4 hunks FAILED -- saving rejects to file webform_report.inc.rej
$ patch -p0 < webform_report_6.x-1.11_date_range_feature_module.patch
patching file webform_report.module
Hunk #1 FAILED at 213.
Hunk #2 FAILED at 274.
Hunk #3 FAILED at 393.
Hunk #4 FAILED at 455.
Hunk #5 FAILED at 494.
Hunk #6 FAILED at 522.
Hunk #7 FAILED at 565.
7 out of 7 hunks FAILED -- saving rejects to file webform_report.module.rej
I do not know what I am doing wrong. I tried to install inc. patch first and then module.patch and the viceversa. Please let me know if you can help me.
Thank you.
Comment #15
jimbullington commentedUnfortunately the patch is for the 6.x-2.0 version of this module. No more development is being done on the 1.0 version.
Comment #16
droath commentedHi meordonez -
I just retested my original patch on my local sandbox, and everything seems to be working fine. I did notice that the order of your files in your patch command were backwards. I would suggest running the command this way:
Here are the patch commands that I ran on the module & inc files.
Hope this helps!
Comment #17
jimbullington commentedA new issue along these same lines has been opened for 6.x-2.0 - #969908: Date Range Report Filter Continued.... This was done to aleviate confusion over the patches for 6.x-1.0.
Comment #18
meordonez commentedDroath:
Thank you very much for all your help, I try to install the patch the way you told me but I was not able.
$ patch -p0 webform_report.inc webform_report_6.x-1.11_date_range_feature_inc.patch
patching file webform_report.inc
Hunk #1 FAILED at 54.
Hunk #2 FAILED at 81.
Hunk #3 FAILED at 224.
Hunk #4 FAILED at 244.
4 out of 4 hunks FAILED -- saving rejects to file webform_report.inc.rej
I do not what I am doing wrong. I changed the versions from 6.x-1.0 to 6.x-2.0 but I still cannot apply the patch.
Comment #19
droath commentedmeordonez:
If you are running webform report version 6.X-2.0 you will need to use this patch file #969908: Date Range Report Filter Continued.... The above patch only works on webform report, version 6.x-1.11.
Hope this helps...
Comment #20
meordonez commenteddroath:
thank you very much!, just one question, this patch is for the .module or the .inc file?
Comment #21
droath commentedmeordonez:
There are two files that you will need to patch in the webform_report module, version 6.x-1.11.
One is the .inc file, use this patch file:
webform_report_6.x-1.11_date_range_feature_inc.patch
Second is the .module file, use this patch file:
webform_report_6.x-1.11_date_range_feature_module.patch
Hope this gets you up and running...
Comment #22
meordonez commenteddroath:
I worked! thank you very very much!
Comment #23
jimbullington commented