I’m trying to alter an exposed date filter in a view I created that uses solr search api. I noticed that the end date filter doesn’t work unless I add a day to the end date. so for example if i have the following nodes:
| title | start date | end date |
|---|---|---|
| a | 01/01/2020 | 01/01/2021 |
| b | 02/01/2020 | 02/01/2022 |
| c | 03/01/2020 | 03/01/2023 |
and i use an exposed filter to return the end date of 02/01/2022 with a less than or equal to operator it will not return nodes a and b unless i change the end date to be 02/02/2022.
I’m stuck on trying to figure out how to modify the hook_views_query_alter() to add a time(i’m assuming that’s what is wrong.).
function my_module_views_query_alter(ViewExecutable $view, QueryPluginBase $query) { if ($view->id() == 'my_solr_search' && !empty($view->exposed_raw_input['field_end_date'])) { $query->addWhere(0, 'field_end_date', $view->exposed_raw_input['field_end_date'] . '23:59', '<='); } } 
