import ConsiderDocumentService from '/docs/snippets/consider-document-service.md'
import QueryEnginePrereqs from '/docs/snippets/query-engine-prereqs.md'

Single Operations with the Query Engine API#

The Query Engine API provides methods to find, create, update, and delete individual entries with filtering, selection, pagination, and relation population options.

findOne()#

Finds the first entry matching the parameters.

Syntax: findOne(parameters) ⇒ Entry

Parameters#

Example#

const entry = await strapi.db.query('api::blog.article').findOne({
  select: ['title', 'description'],
  where: { title: 'Hello World' },
  populate: { category: true },
});

findMany()#

Finds entries matching the parameters.

Syntax: findMany(parameters) ⇒ Entry[]

Parameters#

Example#

const entries = await strapi.db.query('api::blog.article').findMany({
  select: ['title', 'description'],
  where: { title: 'Hello World' },
  orderBy: { publishedAt: 'DESC' },
  populate: { category: true },
});

findWithCount()#

Finds and counts entries matching the parameters.

Syntax: findWithCount(parameters) => [Entry[], number]

Parameters#

Example#

const [entries, count] = await strapi.db.query('api::blog.article').findWithCount({
  select: ['title', 'description'],
  where: { title: 'Hello World' },
  orderBy: { title: 'DESC' },
  populate: { category: true },
});

create()#

Creates one entry and returns it.

Syntax: create(parameters) => Entry

Parameters#

Example#

const entry = await strapi.db.query('api::blog.article').create({
  data: {
    title: 'My Article',
  },
});

update()#

Updates one entry and returns it.

Syntax: update(parameters) => Entry

Parameters#

Example#

const entry = await strapi.db.query('api::blog.article').update({
  where: { id: 1 },
  data: {
    title: 'xxx',
  },
});

delete()#

Deletes one entry and returns it.

Syntax: delete(parameters) => Entry

Parameters#

Example#

const entry = await strapi.db.query('api::blog.article').delete({
  where: { id: 1 },
});