nestjs-paginate
nestjs-paginate copied to clipboard
ppetzold
Pagination and filtering helper method for TypeORM repositories or query builders using Nest.js framework :book::paperclip:
env: [email protected] [email protected] mysql community 8.0.19 ``` ts @Entity() export class YyyPaginate { @PrimaryGeneratedColumn() id: number; @Column() name: string; @Column({ nullable: true }) lastName: string; @Column({ default: true }) isActive:...
How to use filterableColumns with Postgres `JSONB` ? ```ts const assigned_bids = await paginate(request, qb, { relations: ['product', 'statuses', 'basisBuyer'], sortableColumns: sortBy.map((e) => e[0]) as PaginateConfig['sortableColumns'], searchableColumns: (request.searchBy as PaginateConfig['searchableColumns'])...
Hello, thank you for your very useful library. Unfortunately, we have some issues with multi filters. `orders?filter.families=$ilike:REMOV&filter.families=$or:$ilike:IMPLANT&filter.dentistName=$ilike:b` The generated request is : ``` WHERE (UPPER(`product`.`families`) LIKE UPPER(?) OR UPPER(`product`.`families`) LIKE...
Currently the `Paginate` decorator does `(_data: unknown, ctx: ExecutionContext) => PaginateQuery`, but is encapsulated as a parameter decorator factory. However, when I'm unit testing, I haven't figured out how to...
If we use a filter that include a relation that is not eagery loaded or loaded it will make an error ```typescript it('should filter nested relations', async () => {...
This is my request `/grants?page=1&limit=5` Result meta is ``` "meta": { "itemsPerPage": 5, "totalItems": 12, "currentPage": 1, "totalPages": 3, "sortBy": [ [ "role", "ASC" ], [ "grants.application", "ASC" ] ]...
https://github.com/ppetzold/nestjs-paginate/blob/3c96e99836f25d4f9143adcb32d07b44ef93bfbf/src/decorator.ts#L81 Using a string value for `page` that is not a numer string, the value is parsed as number but with value `NaN`. Ex: http://localhost/?page=foo ```ts { page: NaN, limit:...
Please export the functions in [`swagger/api-paginated-query.decorator.ts`](https://github.com/ppetzold/nestjs-paginate/blob/master/src/swagger/api-paginated-query.decorator.ts) so we can easily reuse and override them.
I request the addition of tsvector/tsquery search support to `nestjs-paginate`. This feature, highlighted in a recent article (source: https://xata.io/blog/postgres-full-text-search-engine), enables fast and reliable full-text searches in Postgres databases. After discovering...
This changeset implements the following syntactic changes: * Change `page` to `page[number]` * Change `limit` to `page[size]` * Change `sortBy` to `sort` * Change current syntax (`field:ASC/DESC`) to a comma...