Incorrect page total when filtering db and adding pagination

[Prince2k3]

Describe the bug

Hello!

I'm experiencing an issue with the pagination.

As example when I have code like this

...
.paginate(on: request, response: APIPaginated.self) { builder in
            if let fromDate = fromDate {
                return builder
                .filter(\.userId == userId)
                .filter(\.closed == false)
                .filter(\.createdAt >= fromDate)
                .sort(\.createdAt)
                .all()
            } else {
                return builder
                .filter(\.userId == userId)
                .filter(\.closed == false)
                .sort(\.createdAt)
                .all()
            }
        }

Things work but the total is the wrong total and not based on the filtered total.

Steps To Reproduce Steps to reproduce the behavior:

1. make a custom paginated response
2. paginate your data with filters
3. notice the total is wrong

Expected behavior I expect that when I query and filter the db the total would reflect the total after filtering

Version Information

• OS: macOS
• Vapor Version: 3.3.1
• Fluent Version: 3.2.1