Delete Records

Field Name

Description/Use

Type/Options 

Optional/Mandatory

Data source

This is the name of the table into which the data should be added.

Text

Mandatory

Selection

With this option, you get the Selection Editor, which allows you to specify which data you want to delete from your resource data table. By defining the selection criteria, you can limit the data you want to delete.

Selection operators vary by variable type as follows:

• numeric fields: equals, not equals, is larger (or equal) than, is smaller (or equal) than, in, not in
• text fields: equals, not equals, is not, like, equals or empty, in, not in

Use like with leading and/or trailing wildcard (%) if necessary

In, and not in comparison value must be a collection as text, quoted and comma separated. Use the format variable part to do the conversion. Note that if the collection is empty, this term only is dropped from the query to avoid an error from "where target in {null}."

Complex criteria can be built using the editor by using AND/OR (toggle to switch) and adding parentheses around specific terms to define the precise selection rules.

Advanced Note: while less commonly used, the greater than/smaller than rules for numeric fields can also be applied to text fields, as per SQL

Log data object

The data object that stores the error messages from the execution of the database parts: add data record, get data record, update data record, delete data record and import values. Hence, when the log data object is specified, the error message and stack trace of a database part will be stored to the object in case of errors.

When used by multiple database parts, the Log data object will store the cumulative list of error messages from the different parts.

Text

Optional

Reset log data object

When this is checked the system will clear the error messages from the Log data object. Typically, this option should be checked in the first database part of a sequence of database parts.

Checkbox

Optional

Skip on error

When this is checked the system will skip the execution of subsequent database parts linked to the same Log data object. 

Checkbox

Optional