# Entity Service API: Ordering & Pagination

The Entity Service API offers the ability to order and paginate results found with its findMany() method.

# Ordering

To order results returned by the Entity Service API, use the sort parameter. Results can be ordered based on a single or on multiple attribute(s) and can also use relational ordering.

# Single

To order results by a single field, just pass it to the sort parameter:

  • either as a string to sort with the default ascending order
  • or as an object to define both the field name and the order (i.e. 'asc' for ascending order or 'desc' for descending order)
strapi.entityService.findMany('api::article.article', {
  sort: 'id',
});

// single with direction
strapi.entityService.findMany('api::article.article', {
  sort: { id: 'desc' },
});

# Multiple

To order results by multiple fields, pass the fields as an array to the sort parameter:

  • either as an array of strings to sort multiple fields using the default ascending order
  • or as an array of objects to define both the field name and the order (i.e. 'asc' for ascending order or 'desc' for descending order)
strapi.entityService.findMany('api::article.article', {
  sort: ['publishDate', 'name'],
});

// multiple with direction
strapi.entityService.findMany('api::article.article', {
  sort: [{ title: 'asc' }, { publishedAt: 'desc' }],
});

# Relational ordering

Fields can also be sorted based on fields from relations:

strapi.entityService.findMany('api::article.article', {
  sort: {
    author: {
      name: 'asc',
    },
  },
});

# Pagination

To paginate results returned by the Entity Service API, use the start and limit parameters:

strapi.entityService.findMany('api::article.article', {
  start: 10,
  limit: 15,
});