I have a column called 'attendance.attendance_date'. The calendar view query was being generated with the correct column name in the SELECT clause, but it was 'attendance.attendance.date' in the WHERE clause.

The problem was a str_replace that replaced all 'tablename_' with 'tablename.' including any column name including 'tablename_'.

Here's a patch...

CommentFileSizeAuthor
date_api_argument_handler.inc_.patch1.09 KBbrendanxc

Comments

damienmckenna’s picture

damienmckenna
Location TN, USA
commented
Issue summary: View changes
Status: Active » Closed (won't fix)

Unfortunately the Drupal 6 version of the Date module is no longer supported. That said, we appreciate that you took time to work on this issue. Should this request still be relevant for Drupal 7 please feel free to reopen it. Thank you.