...
This operator takes a list and a filter and deletes all the elements that match the filter. The filter may be templated, in which case a parent table needs to be provided and its rows will be used to instantiate the filter.
Operator Usage in Easy Mode
- Click + on the parent node.
- Enter the Selectively Delete from List operator in the search field and select the operator from the Results to open the operator form.
- In the Name drop-down, enter or select the name of the list.
In the Filter, apply filters to selectively delete the data row from the list using AND or OR operator to delete the data row.
Enter or select a column value from the drop-down.
- Select the operator (=, !=, >, >=, \< , \<=)
Enter the value to delete from the list.
You can add Rule by clicking on + Rule to delete with conditions.
You can also create groups by clicking on + Group and repeat from step 4.Optional. In the Table drop-down, enter or select a table that contains input values to delete from.
When you select the table names, the Pick Value appears in the filter from which you can select the column values to delete.- Click Run to view the result.
- Click Cancel to discard the operator form.
- Click Submit to add the operator to the playbook.
Usage Details
LQL Command
Code Block |
---|
selectivelyDeleteFromList(list_name, filter, input_table) |
...