Add the ability to use offset and limit instead of take and skip. about nestjs-typeorm-paginate HOT 4 CLOSED

skip to offset will be used in sql distinct to check for the uniqueness of records. this greatly affects the time of the request. At the same time, if the tables are designed in such a way that there are unique records, then there is no need for distinct.

from nestjs-typeorm-paginate.

Sure, been thinking about offering a "more option" strategy like

const pagination = paginate<Pagination<Entity, MyCustomPaginationMetadata>>({
   repository,
   metaTransform: (meta: PaginationMetadata): MyCustomMetadata => ({...meta}),
   conditions: {
     where: {
       name: "test",
     },
   },
   methodOfSeparation: 'skip', // 'limit' | 'skip',
});

and other options etc

from nestjs-typeorm-paginate.

@LoginovSO just a question though, why would you want to do this specifically?

from nestjs-typeorm-paginate.

ah yes, that makes sense! I'll look into it!

from nestjs-typeorm-paginate.