Using ScanAndCount the BeforeSelect Hook is not called when Getting the Count using Pagination.

[ocomsoft]

I am using BeforeSelect to add a filter for tenants and when use ScanAndCount the COUNT SQL does not include the where clause for the Tenant added in BeforeSelect when the results are Paginated.

Using the source attached you can see the tenant is not applied when calling ScanAndCount. Uses zerolog because that is how we found it.

example.zip

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[ocomsoft]

This is a real bug