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
Section titled “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
Section titled “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
Section titled “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
Section titled “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
Section titled “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)
Section titled “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)
Section titled “Values (SET)”Map each column you want to update to a value. Values can be expressions, like $_POST inputs, or fixed constants.
Conditions (WHERE)
Section titled “Conditions (WHERE)”The WHERE builder defines which rows are affected. Use grouped AND/OR logic and parameterized expressions to prevent accidental mass-updates.
Preview
Section titled “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
Section titled “Close the Updater dialog”When finished reviewing, you can close the Database Updater dialog to return to the Server Connect editor.
Next steps
Section titled “Next steps”Continue with INSERT or DELETE, or return to the Database actions hub.