Question / Problem:
Kofax Analytics for Capture (KAFC) includes historical data which does not need to be preserved. Is there any method to delete a Date Range of data from all tables of the KAFC Data database?
Answer / Solution:
The appropriate Execution Plan to use for specific date deletion of data from the KAFC Data database is the "Delete Data by Time"
Steps to delete data be Date:
Navigate to the Data Loader (../Insight/dataload)
- Execution Plans will be displayed
Scroll Down to 'Delete Data By Time' & select the 'LOAD' button
Date Range - From date: select the option for "Beginning of times (1/1/1900 12:00AM)
Date Range - To date: select the option for "Specific Date" and use the calendar button to select the desired date/time
LOAD Data (use this button to process the Execution Plan)
The Data Load screen will update with status to show a Task (Delete Data by Time) has been scheduled/processed with a result of 'Success'