Paginate with queryBuilder counts raw number of rows instead of entity number of rows.

[linconsdev]

This is the meta output for only 40 rows of one entity. Im using queryBuilder and leftJoinAndMapOne and mapMany to get relationships.
I don't understand where this totalItems number 2559 is coming from.
It is easy to replicate, happens on every queryBuilder I've made.

Can this issue be addressed?

[linconsdev]

Can we have this solution merged into actual package?

[salauddinn]

I am also facing the same similar issue related limit i should get 20 results but ended up getting 3 only i am using subquery way but query results coming fine but problem with pagination

[psam44]

@linconsdev or @bashleigh , please consider closing this issue as a duplicate of 627.