With the function Delete data record it is possible to delete one or several data records from a JobData table. Therefore, search criteria can be determined on the basis of table columns.
The following settings can be made:
Setting |
Description |
|---|---|
JobData table |
Select the JobData table, from which the data should be removed. |
Fixed subtable |
If you want to remove several data records, you can select one of the process subtables here, and use it for the search criteria of the input parameters. |
No Hit |
Here you can define the procedure, which should be used, if no hit was scored based on the search criteria. Options: •Ignore (Default) - there is no feedback, the step is executed and finished normally. •Cancel - the step creates an error and an error message is displayed in the step overview. |
Input parameters |
Description |
|---|---|
Maximum number of data records to be deleted |
With this setting it is possible to limit the number of data records to be deleted. If, based on the search criteria, e.g. 3 data records are found, but the setting has the value 2, only 2 data records will be deleted. A note about that is recorded in the JobData log file (output/log directory, warning level). |
Search filter |
Links table columns with process data to define search criteria for the entries, which have to be deleted. |
Output parameters |
Description |
|---|---|
Record-ID |
The unequivocal identifier of the new data record (one or several). |
Return code |
In case of an error, the return code -1 will be displayed in the indicated field. |
Error message |
Determine, where the error messages, occurring during the execution of the function, should be stored. |
Example
JobData table COMPANY_VEHICLES :
JRID |
REG_NUMBER |
VTYPE |
ASSET_NO |
|---|---|---|---|
12345 |
MA-JR 2018 |
XC60 T6 |
C73-00-83 |
12346 |
MA-JR 2017 |
V60 D4 |
A13-12-51 |
12347 |
MA-JR 1111 |
XC60 D5 |
C-27-59-77 |
12348 |
MA-JR 2233 |
XC60 T6 |
C73-23-34 |
12349 |
MA-JR 2211 |
XC60 D5 |
C73-25-56 |
Configuration:
General settings
Input parameters
Output parameters
Execution with vehicle type "XC60 D5". Content of JobData table COMPANY_VEHICLES:
JRID |
REG_NUMBER |
VTYPE |
ASSET_NO |
|---|---|---|---|
12345 |
MA-JR 2018 |
XC60 T6 |
C73-00-83 |
12346 |
MA-JR 2017 |
V60 D4 |
A13-12-51 |
12348 |
MA-JR 2233 |
XC60 T6 |
C73-23-34 |
Content of subtable:
VID |
|---|
12347 |
12349 |
