Closed (won't fix)
Project:
Views (for Drupal 7)
Version:
6.x-2.7
Component:
exposed filters
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Nov 2009 at 12:51 UTC
Updated:
10 Nov 2009 at 16:53 UTC
I create an exposed filter with
- node post date
- cck field date (dataevento)
- date1 OR date2 conditions
- "is beetwen" conditions
I check in the query and post date doesn't appear.
____________
WHERE (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_dataevento.field_dataevento_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(3600)), '%Y-%m-%%d') >= '2006-02-02' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_dataevento.field_dataevento_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(3600)), '%Y-%m-%%d') <= '2012-02-02') OR (DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_dataevento.created), SEC_TO_TIME(3600)), '%Y-%m-%%d') >= '2006-02-02' AND DATE_FORMAT(ADDTIME(FROM_UNIXTIME(node_data_field_dataevento.created), SEC_TO_TIME(3600)), '%Y-%m-%%d') <= '2012-02-02')
______________
Comments
Comment #1
merlinofchaos commentedPlease read the issue submission guidelines regarding where issues about fields provided by modules should be posted.