When querying using filters, or when using pagination, count should not return the amount or returned rows, but the amount of rows matching the filter params.
This PR:
Defines dataQuery and countQuery builder
Implements data fetching buy calling both the data and count query in a single transaction
When querying using filters, or when using pagination, count should not return the amount or returned rows, but the amount of rows matching the filter params.
This PR: