Changelog 3.0.5

• Added warning logs in case invalid filter data passed.

Changelog 3.0.4

• Fixed PaginationDto for "$in" operator
• Remove unusual log
• Updated Examples

Changelog 3.0.3

• Added support for nested field name in filterDto
• Done some corrections in PaginationDto
• Added OOP based approach initially

Changelog 3.0.2

• fixed crash when sort value is null
• fixed nextKeyFn crash issue

Changelog 3.0.1

• This version is backward compatible.
• Added $in and $nin mongo operator support in DTO.

Installation

Use the package manager npm to install Nestjs-Keyset-Paginator.

1npm i nestjs-keyset-paginator

Usage

• In example.controller.ts, use PaginationDto to Validate params and pass it to the service.

1import { PaginationDto, projectionDto } from 'nestjs-keyset-paginator'
2
3@Controller('example')
4export class ExampleController {
5  constructor(private readonly exampleService: ExampleService) {
6  }
7
8  @Get()
9  findAll(@Body() params: PaginationDto) {
10    return this.exampleService.findAll(
11      params.skip,
12      params.limit,
13      params?.start_key,
14      params?.sort?.field,
15      params?.sort?.order,
16      params?.filter,
17      params?.projection
18    )
19  }
20}

• Then in example.service.ts, pass those params to "paginate()" along with you model (Mongoose Model).

1import paginate, { filterDto, projectionDto } from 'nestjs-keyset-paginator'
2
3@Injectable()
4export class ExampleService {
5  constructor(
6    @Inject(EXAMPLE_MODEL)
7    private readonly exampleModel: Model<ExampleDocument>
8  ) {
9  }
10
11  async findAll(
12    skip = 0,
13    limit = 10,
14    start_key?,
15    sort_field?: string,
16    sort_order?: number,
17    filter?: filterDto[],
18    projection?: projectionDto[]
19  ) {
20    return paginate(this.exampleModel, skip, limit, start_key, sort_field, sort_order, filter, projection)
21  }
22}

• The paginate function will return with the promise:

{ docs: docs, next_key }

---

Example param

• Refer to src/common.types.ts for all supported filters and search types.

Example:-

1{
2  "filter": [
3    {
4      "name": "score",
5      "value": 400,
6      "operator": "lt"
7    },
8    {
9      "name": "isPassed",
10      "value": true,
11      "operator": "eq"
12    },
13    {
14      "name": ["outer_field_name", "inner_field_name"],
15      "value": "user one",
16      "operator": "eq"
17    },
18    {
19      "name": "time",
20      "arr_value": [40, 60],
21      "operator": "in"
22    },
23    {
24      "name": "left_count",
25      "arr_value": [0, 1],
26      "operator": "nin"
27    }
28  ],
29  "sort": {
30    "field": "score",
31    "order": 1
32  },
33  "projection": [
34    {
35      "name": "password",
36      "mode": 0
37    }
38  ],
39  "limit": 4
40}

• As response, you will also get "next_key".

Example:

1{
2  "next_key": [
3    {
4      "key": "_id",
5      "value": "61a4c444f9534392c70afaf6"
6    },
7    {
8      "key": "score",
9      "value": 100
10    }
11  ]
12}

• To get the next page, use this "next_key" object as "start_key" in the next request.

Example:

1{
2  "filter": [
3    {
4      "name": "score",
5      "value": 400,
6      "operator": "lt"
7    },
8    {
9      "name": "isPassed",
10      "value": true,
11      "operator": "eq"
12    }
13  ],
14  "sort": {
15    "field": "score",
16    "order": 1
17  },
18  "limit": 4,
19  "start_key": [
20    {
21      "key": "_id",
22      "value": "61a4c444f9534392c70afaf6"
23    },
24    {
25      "key": "score",
26      "value": 100
27    }
28  ]
29}

• If you provide "start_key", this will skip previous documents.

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate (if applicable).

License

MIT