listAndCount Method - Service Factory Reference

This method of a module's service retrieves a list of records with the total count.

The method's name is listAndCountDataModel, where DataModel is the plural pascal-case name of the data model.

Retrieve List of Records#

Code
const [posts, count] = await postModuleService.listAndCountPosts()

If no parameters are passed, the method returns an array with two items:

1. The first is an array of the first 15 records retrieved.
2. The second is the total count of records.

Filter Records#

Code
1const [posts, count] = await postModuleService.listAndCountPosts({2  id: ["123", "321"],3})

Parameters#

To retrieve records matching a set of filters, pass an object of the filters as the first parameter.

Returns#

The method returns an array with two items:

1. The first is an array of the first 15 records retrieved matching the specified filters.
2. The second is the total count of records matching the specified filters.

Retrieve Relations#

Code
1const [posts, count] = await postModuleService.listAndCountPosts({}, {2  relations: ["author"],3})

Parameters#

To retrieve records with their relations, pass an object with a relations property as the second parameter. Its value is an array of relation names.

Returns#

The method returns an array with two items:

1. The first is an array of the first 15 records retrieved.
2. The second is the total count of records.

Select Properties#

Code
1const [posts, count] = await postModuleService.listAndCountPosts({}, {2  select: ["id", "name"],3})

Parameters#

By default, retrieved records have all their properties. To select specific properties to retrieve, pass a select property in the second object parameter.

select's value is an array of property names to retrieve.

Returns#

The method returns an array with two items:

1. The first is an array of the first 15 records retrieved.
2. The second is the total count of records.

Paginate Records#

Code
1const [posts, count] = await postModuleService.listAndCountPosts({}, {2  take: 20,3  skip: 10,4})

Parameters#

To paginate the returned records, the second object parameter accepts the following properties:

• take: a number indicating how many records to retrieve. By default, it's 15.
• skip: a number indicating how many records to skip before the retrieved records. By default, it's 0.

Returns#

The method returns an array with two items:

1. The first is an array of the records retrieved. The number of records is less than or equal to take's value.
2. The second is the total count of records.

Sort Records#

Code
1const [posts, count] = await postModuleService.listAndCountPosts({}, {2  order: {3    name: "ASC",4  },5})

Parameters#

To sort records by one or more properties, pass an order property in the second object parameter. Its value is an object whose keys are the property names, and values can either be:

• ASC to sort by this property in the ascending order.
• DESC to sort by this property in the descending order.

Returns#

The method returns an array with two items:

1. The first is an array of the first 15 records retrieved.
2. The second is the total count of records.