Hi,
I use the calendar view to display opening times by week. Therefore, I created a content type called "opening_hours" with date values (begin_date and end_date) and display it in the calendar for the current week. The begin_date is always a monday, and the end_date always a sunday.
The problem arise with 2 different contents following each other:
ex:
week1: monday 2013-05-13 - sunday 2013-05-19.
week2: monday 2013-05-20 - sunday 2013-05-26.
With the 2013-W20 as contextual filter (week of May, 13-19), the week1 AND week2 are displayed.
Indeed, the view query writes:
"(DATE_FORMAT(field_data_field_period_hours.field_period_hours_value2, '%Y-%m-%d %H:%i:%s') >= '<strong>2013-05-13</strong> 00:00:00' AND DATE_FORMAT(field_data_field_period_hours.field_period_hours_value, '%Y-%m-%d %H:%i:%s') <strong><=</strong> '<strong>2013-05-20</strong> 00:00:00') )"
Should not the query be :
"(DATE_FORMAT(field_data_field_period_hours.field_period_hours_value2, '%Y-%m-%d %H:%i:%s') >= '<strong>2013-05-13</strong> 00:00:00' AND DATE_FORMAT(field_data_field_period_hours.field_period_hours_value, '%Y-%m-%d %H:%i:%s') <= '<strong>2013-05-19</strong> 00:00:00') )"
OR
"(DATE_FORMAT(field_data_field_period_hours.field_period_hours_value2, '%Y-%m-%d %H:%i:%s') >= '<strong>2013-05-13</strong> 00:00:00' AND DATE_FORMAT(field_data_field_period_hours.field_period_hours_value, '%Y-%m-%d %H:%i:%s') <strong>< </strong>'<strong>2013-05-20</strong> 00:00:00') )"
?
Could you help with this? Can I modify this somewhere?
Thanks in advance for your answer,
Best regards,
Read more
Comments
Comment #1
audealexandre CreditAttribution: audealexandre commentedSee also the post http://drupal.org/node/1588198#comment-7406540 which describes the same problem. I suppose it is better to close this one?
Comment #2
apadernoComment #3
Neslee Canil PintoHi, there will be no more future development for 7.x branch. If you see this issue in 8.x, feel free to file an issue. Close this as Outdated.