Closed (duplicate)
Project:
Date
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Apr 2009 at 19:02 UTC
Updated:
20 Apr 2009 at 20:57 UTC
When entering a filter regarding a date (e.g. looking for new members that joined today) the input in the field 'Date Default' seems to be ignored in the resulting SQL-Query. When entering the current date using the buttons (select year, select month, select day) it works fine
Example:
The Menu shows as filter
Filter
Node: Typ = Mitglied
Einstellungen
Datum: Datum Inhalt: Mitglied seit (field_mitglied_seit) = 2009-04-16 00:00:00
The tail of the query is:
WHERE (node.type in ('mitglied'))
AND (DATE_FORMAT(STR_TO_DATE(node_data_field_mitglied_seit.field_mitglied_seit_value, '%Y-%m-%dT%T'), '%Y-%m-%d') = '2009-04-16')
ORDER BY node_data_field_mitglied_seit_field_mitglied_name_value ASC
When entering the current date in the field 'Date Default'
The result is:
Menu shows as filter
Filter
Node: Typ = Mitglied
Einstellungen
Datum: Datum Inhalt: Mitglied seit (field_mitglied_seit) = 2009-04-16 00:00:00
The tail of the query is:
WHERE node.type in ('mitglied')
ORDER BY node_data_field_mitglied_vorname_field_mitglied_name_value ASC
Comments
Comment #1
pieterdcI'm encountering the exact same problem.
Comment #2
yched commentedSaving one for marlinofchaos - from the issue submssion guidelines :
"If you only read one of these submission guidelines, read this one. (Then please read the rest) If your problem deals exclusively with fields or filters provided by another module (CCK, Image, VotingAPI are common) please post the issue under the queue for that module first; all modules are responsible for telling Views about their own fields. It's possible Views IS at fault, but the module maintainers are the best people to make that determination, and they can kick the issue into the Views queue with an explanation of what's wrong if that is the case."
Please update the issue description with the version of date.module you are using.
Also, this area in date has seen seen several changes, so I'd suggest trying latest date _dev.
Comment #3
pieterdcI can confirm this bug is fixed in dev (6.x-2.x-dev 2009-Apr-13).
See also duplicate: #426990: Views filter "Date (field_event_date) - From date >= now" doesn't work anymore?