Delete Database Record(s)

Open

From which database?

If Profound.js has been configured for multiple connections, this allows you to select the appropriate database connection for this step. If a database is not selected, the default connection will be used.

From which database table?

Select a database table to delete records from.

Selection criteria expression

Provide a WHERE-clause expression to identify the records. Use the dropdown to create the expression without having to write code manually.

Question marks (?) in the expression are used to identify dynamic values, which are also referred to as selection parameter values. For each question mark, you will be prompted to provide a selection parameter value, where you can select or manually type dynamic content.

Capture results into

Capture result information into an output property or into a work variable. The captured information is an object with the following properties:

• success

• affectedRows

• message

• sqlcode

When not successful, the message and sqlcode properties can help inform the user as to why it failed.

Open