nestjs-typeorm-paginate

nestjs-typeorm-paginate copied to clipboard

Counter error on queries with orderBy on SQLServer

1

Hello all When making queries order by on SQLServer, method countQuery need set orderBy to undefined to get expected result ``` const queryBuilder = this.fakultasRepository.createQueryBuilder('fakultas) .innerJoin(ProgramStudiEntity, 'programStudi', 'fakultas.idProdi = programStudi.id')...

fuadmuhtaz

Actual fix for #614 Note that you have both yarn.lock & package-lock.json. One should be removed. Chalk v5 broke postinstall script.

GerkinDev

Paginate does not work together with PostgreSQL queries containing "DISTINCT ON"

1

Example TypeORM Query with working expected results: ```ts // Getting all Res1 records for a user with ${username} but only for the latest series identified with `seriesId` const typeormQuery =...

schuerg

paginateRaw enforcing groupBy when it is not needed

1

I have the following query I would like to get the facilities along with the AVG review of each when done like this **WITHOUT** the pagianteRaw or pagiante function it...

GhettoBurger996

Add Expose decorator to all fields on Pagination class

1

In my project, I use: ```typescript app.useGlobalInterceptors( new ClassSerializerInterceptor(app.get(Reflector), { excludeExtraneousValues: true, }), ); ``` `excludeExtraneousValues: true` is a secure practice that enforces the use of explicit `@Expose()` from `class-transformer`...

ThePooN

ER_DUP_FIELDNAME while using querybuilder with join in v3.1.3

3

The below error occurs while using a query builder with join (tried inner and left join). And, this occurs only in v3.1.3 and not in v3.1.2. ``` code: 'ER_DUP_FIELDNAME', errno:...

shashi-3dqr

Paginate by id

2

Instead of paginating via page, use entity id instead to get the next 10 of object id

bashleigh

GraphQL Support

5

Is there any way to use this with GraphQL? Currently, i am not able to select the correct Query Return Object

danielehrhardt

Cursor-based pagination

2

Hello As we all know offset and limit based pagination have performance issue in large amount of data. I think the best solution is Cursor-based pagination. Do you have any...

abehnamfard

Bumps [typeorm](https://github.com/typeorm/typeorm) from 0.3.6 to 0.3.10. Release notes Sourced from typeorm's releases. 0.3.10 Bug Fixes "Cannot commit, no transaction is active" error in sql.js (#9234) (749809a), closes #9100 add missing...

dependabot[bot]