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.

 
 

Drupal is a registered trademark of Dries Buytaert.