Start Day, Start Month, Start Year filter issue
craigmc - July 30, 2008 - 00:20
| Project: | Event Views |
| Version: | 5.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | craigmc |
| Status: | needs review |
Description
Fixed an issue with the event views module. When trying to use the Filter "Start Day" (for example), the views was just using DAYOFMONTH(event.event_start) which returns null b/c event.event_start is unix_timecode. I modified the event_views.module to use this function and it works great.
I don't know how to do a patch file, so here's the info
in the event_views_handler_filter_ymd function around line 247
replace
$sql = $filterinfo['type'] ."(event.event_start)";
with
$sql = $filterinfo['type'] ."(from_unixtime(event.event_start))";
Save. And you're good to go.
