Closed (duplicate)
Project:
Date
Version:
5.x-1.3
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
6 Mar 2007 at 13:39 UTC
Updated:
6 Mar 2007 at 13:44 UTC
I want to define a filter on view saying something like "display job vacancies whose closing date is today or any day in the future". For this purpose, there is a keyword 'now' (the documentation reads as "Enter 'now' to use the current time") which should be translated to the NOW() function of MySQL. What happens, though, is that the SQL query looks something like
SELECT node.nid,
node_data_field_job_title.field_job_title_value AS node_data_field_job_title_field_job_title_value,
node_data_field_job_branch.field_job_branch_value AS node_data_field_job_branch_field_job_branch_value
FROM dr_node node LEFT JOIN dr_content_type_job_vacancy node_data_field_job_closing_date ON node.vid = node_data_field_job_closing_date.vid LEFT JOIN dr_content_type_job_vacancy node_data_field_job_title ON node.vid = node_data_field_job_title.vid LEFT JOIN dr_content_type_job_vacancy node_data_field_job_branch ON node.vid = node_data_field_job_branch.vid
WHERE
( REPLACE(node_data_field_job_closing_date.field_job_closing_date_value,'T',' ')
>=
'ERROR') LIMIT 0, 100
where the 'now' keyword got translated into 'ERROR' instead of 'NOW()'. I suspect that this is a fault of date module but I am not sure. Can anyone confirm this or suggest what to do?
Comments
Comment #1
Borek-1 commentedSorry, this is duplicate. See http://drupal.org/node/122124