Date pager does not respect filter

Thanks (again!) @sleitner.
I merged it, but honestly with reviewing not entirely sure if it will work with all possible queries as sub queries.
So please come back in case there are any issues.

Sorry, I had to take back your changes.
The original view's queries did not join properly.

I tried the patch and get this error:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'startDate' in field list is ambiguous

I think so

I couldn't get MR9 applied. It might be that it needs to be against 2.0.x instead of 8.x-1.x.

Using MR10 I now get:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'startDatePager' in field list is ambiguous

#8 does not compatipbe with current 2.1.1-alpha2
I tried to patch it manually, but I received "The website encountered an unexpected error. "

There is an error in Drupal's log.
Message
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'startDate' in field list is ambiguous: SELECT MIN(startDate) AS "min", MAX(endDate) AS "max" FROM "node__field_start" "node__field_start" INNER JOIN (SELECT "node_field_data"."langcode" AS "node_field_data_langcode", "node__field_start"."field_start_value" AS "node__field_start_field_start_value", "node_field_data"."nid" AS "nid", "node__field_start"."field_start_value" AS "startDate", "node__field_start"."field_start_value" AS "endDate" FROM "node_field_data" "node_field_data" LEFT JOIN "node__field_start" "node__field_start" ON node_field_data.nid = node__field_start.entity_id AND (node__field_start.deleted = :views_join_condition_0 AND node__field_start.langcode = node_field_data.langcode) INNER JOIN "taxonomy_index" "taxonomy_index" ON node_field_data.nid = taxonomy_index.nid WHERE ((taxonomy_index.tid = :taxonomy_index_tid)) AND (("node_field_data"."status" = :db_condition_placeholder_0) AND ("node_field_data"."langcode" IN (:db_condition_placeholder_1)) AND ((DATE_FORMAT((node__field_start.field_start_value + INTERVAL 3600 SECOND), '%Y-%m-%d\T%H:%i:%s') >= DATE_FORMAT(('2025-02-23T06:47:16' + INTERVAL 3600 SECOND), '%Y-%m-%d\T%H:%i:%s')))) ORDER BY "node__field_start_field_start_value" ASC) "node_field_datanidnode__field_startentity_idANDnode__field_startdeleted0ANDnode__field_startlangcodenode_field_datalangcode" INNER JOIN (SELECT "node_field_data"."langcode" AS "node_field_data_langcode", "node__field_start"."field_start_value" AS "node__field_start_field_start_value", "node_field_data"."nid" AS "nid", "node__field_start"."field_start_value" AS "startDate", "node__field_start"."field_start_value" AS "endDate" FROM "node_field_data" "node_field_data" LEFT JOIN "node__field_start" "node__field_start" ON node_field_data.nid = node__field_start.entity_id AND (node__field_start.deleted = :views_join_condition_0 AND node__field_start.langcode = node_field_data.langcode) INNER JOIN "taxonomy_index" "taxonomy_index" ON node_field_data.nid = taxonomy_index.nid WHERE ((taxonomy_index.tid = :taxonomy_index_tid)) AND (("node_field_data"."status" = :db_condition_placeholder_0) AND ("node_field_data"."langcode" IN (:db_condition_placeholder_1)) AND ((DATE_FORMAT((node__field_start.field_start_value + INTERVAL 3600 SECOND), '%Y-%m-%d\T%H:%i:%s') >= DATE_FORMAT(('2025-02-23T06:47:16' + INTERVAL 3600 SECOND), '%Y-%m-%d\T%H:%i:%s')))) ORDER BY "node__field_start_field_start_value" ASC) "node_field_datanidtaxonomy_indexnid"; Array ( [:taxonomy_index_tid] => 59 [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => en [:views_join_condition_0] => 0 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 45 of /var/www/html/web/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Backtrace

#0 /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php(883): Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException()
#1 /var/www/html/web/core/lib/Drupal/Core/Database/Query/Select.php(524): Drupal\Core\Database\Connection->query()
#2 /var/www/html/web/modules/contrib/date_pager/src/Plugin/views/pager/DatePager.php(429): Drupal\Core\Database\Query\Select->execute()
#3 /var/www/html/web/modules/contrib/date_pager/src/Plugin/views/pager/DatePager.php(441): Drupal\date_pager\Plugin\views\pager\DatePager->getDateRange()

DeepSeec resolve this so I attach new patch.

Maybe test failed, but its works :)

Just tried this patch, it seem to work fine as long as the view has no cache enabled.

Yes I believe I tried the latest patch. Works fine when no cache is set on the view, but on tag based cache, my view was resetting the pager to only one page using this pager. My view is also set to use ajax.