Steps to Duplicate
- Run the 2 pieces of SQL and note the numbers (assuming your date is 1 month ago from today)
select COUNT (*) as Recordstoprocess from CONSTITUENTAUDIT
where DATEADDED < '2018-03-26'
select COUNT (*) as Recordsnottoprocess from CONSTITUENTAUDIT
where DATEADDED > '2018-03-26'
- Setup a purge audit data global change, purge data older than 1 month for the constituent audit table.
- Run the process and note the number of records processed are not what we expected based on the below sql (records to process)
- Run the 2nd piece of SQL again and note the count is lower (ae – it purged data outside of that date range).