---
title: "Delete by Query Operation"
url: "https://docs.ravendb.net/6.2/client-api/operations/common/delete-by-query"
version: "6.2"
language: "nodejs"
---

# Delete by Query Operation

> Client language: Node.js. Also available for [C#](https://docs.ravendb.net/6.2/client-api/operations/common/delete-by-query.md), [Java](https://docs.ravendb.net/6.2/client-api/operations/common/delete-by-query.java.md), [Python](https://docs.ravendb.net/6.2/client-api/operations/common/delete-by-query.python.md), [PHP](https://docs.ravendb.net/6.2/client-api/operations/common/delete-by-query.php.md).
>
> RavenDB publishes an official agent skill for coding assistants at https://docs.ravendb.net/skills/ravendb/SKILL.md (also installable with `npx skills add ravendb/skills`). The skill describes itself as: "Read this before writing any RavenDB query, client call or /databases/ request. Covers server setup, document modelling, the Node.js, .NET and Python clients, RQL, indexes, vector search and AI agents. Code written from recall tends to run and return the wrong rows, because RQL resembles SQL and the clients take field names as plain strings."

> **Note**
>
> - Use `DeleteByQueryOperation` to delete a large number of documents that match the provided query in a single server call.
>
> - **Dynamic behavior**:  
>   The deletion of documents matching the specified query is performed in batches of size 1024.  
>   During the deletion process, documents that are added/modified **after** the delete operation has started  
>   may also be deleted if they match the query criteria.
>
> - **Background operation**:  
>   This operation is performed in the background on the server.  
>   If needed, you can wait for the operation to complete. See: [Wait for completion](https://docs.ravendb.net/6.2/client-api/operations/what-are-operations.nodejs.md#wait-for-completion).
>
> - **Operation scope**:  
>   `DeleteByQueryOperation` runs as a single-node transaction, not a cluster-wide transaction. As a result,  
>   if you use this operation to delete documents that were originally created using a cluster-wide transaction,  
>   their associated [Atomic guards](https://docs.ravendb.net/6.2/client-api/session/cluster-transaction/atomic-guards.nodejs.md) will Not be deleted.
>
>   - To avoid issues when recreating such documents using a cluster-wide session,
>     see [Best practice when storing a document](https://docs.ravendb.net/6.2/client-api/session/cluster-transaction/atomic-guards.nodejs.md#best-practice-when-storing-a-document-in-a-cluster-wide-transaction).
>   - To learn more about the differences between transaction types,
>     see [Cluster-wide transaction vs. Single-node transaction](https://docs.ravendb.net/6.2/client-api/session/cluster-transaction/overview.nodejs.md#cluster-wide-transaction-vs-single-node-transaction).
>
> - In this article:
>   - [Delete by dynamic query](#delete-by-dynamic-query)
>   - [Delete by index query](#delete-by-index-query)
>   - [Syntax](#syntax)

## Delete by dynamic query

> **Note**
>
> ##### Delete all documents in collection
>
> ###### DeleteByQueryOperation
>
> ```javascript
> // Define the delete by query operation, pass an RQL querying a collection
> const deleteByQueryOp = new DeleteByQueryOperation("from 'Orders'");
>
> // Execute the operation by passing it to operations.send
> const operation = await store.operations.send(deleteByQueryOp);
>
> // All documents in collection 'Orders' will be deleted from the server.
> ```
>
> ###### RQL
>
> ```sql
> from "Orders"
> ```

> **Note**
>
> ##### Delete with filtering
>
> ###### DeleteByQueryOperation
>
> ```javascript
> // Define the delete by query operation, pass an RQL querying a collection
> const deleteByQueryOp = new DeleteByQueryOperation("from 'Orders' where Freight > 30");
>
> // Execute the operation by passing it to operations.send
> const operation = await store.operations.send(deleteByQueryOp);
>
> // * All documents matching the specified RQL will be deleted from the server.
>
> // * Since the dynamic query was made with a filtering condition,
> //   an auto-index is generated (if no other matching auto-index already exists).
> ```
>
> ###### RQL
>
> ```sql
> from "Orders" where Freight > 30
> ```

## Delete by index query

- `DeleteByQueryOperation` can only be performed on a **Map-index**.  
  An exception is thrown when executing the operation on a Map-Reduce index.

- A few overloads are available, see the following examples:

> **Note**
>
> ##### A sample Map-index
>
> ```javascript
> // The index definition:
> // =====================
>
> class Products_ByPrice extends AbstractJavaScriptIndexCreationTask {
>   constructor () {
>       super();
>
>       this.map("products", product => {
>           return {
>               Price: product.PricePerUnit
>           };
>       });
>   }
> }
> ```

> **Note**
>
> ##### Delete documents via an index query
>
> ###### DeleteByQueryOperation
>
> ```javascript
> // Define the delete by query operation, pass an RQL querying the index
> const deleteByQueryOp = 
>   new DeleteByQueryOperation("from index 'Products/ByPrice' where Price > 10");
>
> // Execute the operation by passing it to operations.send
> const operation = await store.operations.send(deleteByQueryOp);
>
> // All documents with document-field PricePerUnit > 10 will be deleted from the server.
> ```
>
> ###### DeleteByQueryOperation\_overload
>
> ```javascript
> // Define the index query, provide an RQL querying the index
> const indexQuery = new IndexQuery();
> indexQuery.query = "from index 'Products/ByPrice' where Price > 10";
>
> // Define the delete by query operation
> const deleteByQueryOp = new DeleteByQueryOperation(indexQuery);
>
> // Execute the operation by passing it to operations.send
> const operation = await store.operations.send(deleteByQueryOp);
>
> // All documents with document-field PricePerUnit > 10 will be deleted from the server.
> ```
>
> ###### RQL
>
> ```sql
> from index "Products/ByPrice" where Price > 10
> ```

> **Note**
>
> ##### Delete with options
>
> ###### DeleteByQueryOperation
>
> ```javascript
> // QUERY: Define the index query, provide an RQL querying the index
> const indexQuery = new IndexQuery();
> indexQuery.query = "from index 'Products/ByPrice' where Price > 10";
>
> // OPTIONS: Define the operations options
> // (See all available options in the Syntax section below)
> const options = {
>   // Allow the operation to operate even if index is stale
>   allowStale: true,
>   // Limit the number of base operations per second allowed.
>   maxOpsPerSecond: 500
> }
>
> // Define the delete by query operation
> const deleteByQueryOp = new DeleteByQueryOperation(indexQuery, options);
>
> // Execute the operation by passing it to operations.send
> const operation = await store.operations.send(deleteByQueryOp);
>
> // All documents with document-field PricePerUnit > 10 will be deleted from the server.
> ```
>
> ###### RQL
>
> ```sql
> from index "Products/ByPrice" where Price > 10
> ```
>
> - Specifying `options` is also supported by the other overload methods, see the Syntax section below.

## Syntax

```javascript
// Available overload:
// ===================
const deleteByQueryOp = new DeleteByQueryOperation(indexQuery);
const deleteByQueryOp = new DeleteByQueryOperation(indexQuery, options);
```

| Parameter | Type | Description |
| - | - | - |
| **queryToDelete** | `string` | The RQL query to perform |
| **queryToDelete** | `IndexQuery` | Holds all the information required to query an index |
| **options** | `object` | Object holding different setting options for the operation |

```javascript
// options object
{
  // Indicates whether operations are allowed on stale indexes.
  // DEFAULT: false
  allowStale, // boolean
      
  // If AllowStale is set to false and index is stale,
  // then this is the maximum timeout to wait for index to become non-stale.
  // If timeout is exceeded then exception is thrown.
  // DEFAULT: null (if index is stale then exception is thrown immediately)
  staleTimeout, // number 
      
  // Limits the number of base operations per second allowed.
  // DEFAULT: null (no limit)
  maxOpsPerSecond, // number
}
```

## See also

- [What are Operations](https://docs.ravendb.net/6.2/client-api/operations/what-are-operations.nodejs.md)
- [How to Query](https://docs.ravendb.net/6.2/client-api/session/querying/how-to-query.nodejs.md)
- [Querying: Basics](https://docs.ravendb.net/6.2/indexes/querying/query-index.nodejs.md)
- [What is RQL](https://docs.ravendb.net/6.2/client-api/session/querying/what-is-rql.md)
