# Delete Row

<!-- meta: type=delete-row; location=Database; category=Step (action); platforms=Joomla and WordPress (where applicable) -->

## Overview

Delete Row is a **Step (action)** in **Database**. Deletes rows matching the specified WHERE condition.

When the flow reaches this step, JOrchestrator executes **Delete Row** against your linked site or an external integration, using the field values you set on **General** and **Design**. Downstream steps can read the output payload fields defined for this node.

## Why use this node

Delete Row is a **action step** in the **Database** group. Action steps run in the middle or end of a flow. They perform work on your CMS, call external services, or transform data for the next step.

Typical reasons teams add **Delete Row** to a flow:

- Delete Row on your linked Joomla site when the flow reaches this step
- Delete row based on webhook, schedule, or CMS event data
- Integrate Database operations with messaging, AI, or database steps in one canvas

## Example workflows

Common patterns on the canvas:

1. **Trigger or Webhook** → upstream steps → **Delete Row** → **Send Email** or CMS update
2. **Scheduled trigger** → **Delete Row** → **Debug** (while testing) → production action

## How to set it up

Build WHERE on the Design tab; confirm destructive runs in test environments first.

## Good to know

Use Select Row first to verify which rows match before deleting in production flows.

## Properties panel

The designer shows these tabs for this node:

| Tab | Purpose |
|-----|---------|
| **Info** | Plain-language description and output payload fields for downstream steps |
| **General** | Canvas label and read-only node ID |
| **AI** | Optional assistant to help draft settings from plain language |
| **Design** | Node-specific configuration fields |

### System (automatic — not edited by the user)

These fields are managed by the designer or runtime — you do not type into them directly:

| Property key | Label | Type | Required | Visible when | Notes |
|--------------|-------|------|----------|--------------|-------|
| `_nodeId` | Node ID | `node-id` | No | — | — |
| `whereClause` | WHERE Clause | `where-clause-builder` | No | — | — |

### User-configured — General tab

| Property key | Label | Type | Required | Visible when | Notes |
|--------------|-------|------|----------|--------------|-------|
| `label` | Label | `text` | No | — | Node label |

### User-configured — Design tab

| Property key | Label | Type | Required | Visible when | Notes |
|--------------|-------|------|----------|--------------|-------|
| `tableName` | Table Name | `select` (`#__content` \| `#__categories` \| `#__users` \| `#__usergroups` \| `#__menu` \| `#__modules` \| `#__modules_menu` \| `#__extensions` \| `#__assets` \| `#__languages` \| `#__session` \| `#__tags` \| `#__ucm_content` \| `#__ucm_base` \| `#__contentitem_tag_map` \| `#__finder_links` \| `#__finder_terms` \| `#__finder_tokens` \| `#__finder_tokens_aggregate` \| `#__finder_types` \| `#__newsfeeds` \| `#__overrider` \| `#__redirect_links` \| `#__update_sites` \| `#__update_sites_extensions` \| `#__updates` \| `#__viewlevels` \| `#__workflow_stages` \| `#__workflow_transitions` \| `#__workflows`) | **Yes** | — | Select table or enter custom |

### CMS site configuration (not on this node's properties panel)

Credentials, API keys, mailers, SMTP, and integration defaults are configured in the CMS plugin under **Node Configuration**, not per step on this node. Link the flow to a domain before testing CMS-backed fields.

## Output payload fields

After this step runs, later nodes can reference these fields using placeholders such as
`{{delete_row.deleted}}`.

| Field key | Type | Description |
|-----------|------|-------------|
| `deleted` | boolean | Whether the record was deleted. |
| `rowsAffected` | number | Number of database rows affected. |
| `tableName` | string | Database table name used by the node. |

## Validation rules

- **Table Name** (`tableName`) must be filled before the flow can be saved.

## Related nodes

Other steps in the same area of the palette:

- **Custom Table** (`create-table`) — Database
- **Insert Row** (`insert-row`) — Database
- **Select Row** (`select-row`) — Database
- **Update Row** (`update-row`) — Database