EADeleteFromQuery
This document was generated using Claude.ai
Overview
Executes SQL query to find entities, then deletes all returned entities. Powerful bulk deletion tool with transaction management and error handling options.
When This Action Runs
Manual or automated execution for bulk deletion operations, data cleanup, cascade deletions, and maintenance.
How It Works
- Executes SQL query to find entities (must return entityType and id columns)
- Collects entity list with duplicate prevention and validation
- Runs optional update query before deletion if specified
- Deletes entities individually using proper business logic
- Manages transactions and error handling based on configuration
Parameters
Parameter 1: Query (Required) - SQL query returning entityType and id columns (supports {fieldName} substitution)
Parameter 2: Flush Before Starting (Optional) - "true"/"false" to flush database before deletion
Parameter 3: Do not Delete cancelled Records (Optional) - "true"/"false" to skip cancelled documents
Parameter 4: Flush After Each Delete (Optional) - "true"/"false" to flush after each deletion
Parameter 5: Do In New Transaction - Continue on Errors (Optional) - "true"/"false" for separate transactions with error continuation
Parameter 6: Run Update Query After Selecting Entities, and Before Delete (Optional) - SQL update query to run before deletions
Database Tables Affected
- Query Tables - Any tables referenced by SQL query (read-only)
- Target Entity Tables - Tables of entities returned by query (deleted with business logic)
- Audit Tables - Deletion logs and transaction logs created
Module: core
Full Class Name: com.namasoft.infor.domainbase.util.actions.EADeleteFromQuery