Database: Update (Updater)
Use the Database Updater dialog (opened from a dbupdater UPDATE step) to set values, define WHERE rules, and review conceptual SQL preview.
The Demo Projects HQ UPDATE action opens
Loading the real clients/update.json action from Demo Projects HQ so the Updater dialog uses the project’s live database connection and schema.
The Server Connect editor is now the focus
The action now opens in the dedicated Server Connect editor. Collapse the manager so the workflow tree and Properties panel become the clear focus before selecting the database step.
The UPDATE step is selected
This step selects the update_client workflow step so its SQL/Updater options are shown in the Properties panel.
Locate the "Update Options" button
In the Properties panel, locate the “Update Options” button for the selected UPDATE step. This step matters because Locate the “Update Options” button is part of Serverconnecteditor Properties Control Sql, and understanding that context makes the next action easier to repeat in your own project.
The Updater dialog opens
In the Properties panel, click the “Update Options” button to open the Database Updater dialog for this UPDATE step.
Database Updater dialog (UPDATE)
For UPDATE, you configure two key things: the new values (SET …) and the filtering rules (WHERE …) that decide which rows get updated.
Values (SET)
Map each column you want to update to a value. Values can be expressions, like $_POST inputs, or fixed constants.
Conditions (WHERE)
The WHERE builder defines which rows are affected. Use grouped AND/OR logic and parameterized expressions to prevent accidental mass-updates.
Preview
Use Preview to inspect the generated SQL structure. In Updater dialogs this is conceptual SQL preview only; Preview Data/testing is available in Query Builder dialogs.
Close the Updater dialog
When finished reviewing, you can close the Database Updater dialog to return to the Server Connect editor.
Next steps
Continue with INSERT or DELETE, or return to the Database actions hub.