Skip to content

An IAL set to 'Copy Only New Data' just keeps accumulating records indefinitely — is there a way to have entries older than a certain number of days (like 180) automatically removed, the way history logs get cleaned up?

Answer

No — the 'Copy Only New Data' IAL mode has no built-in logic to remove old records at all; it only ever appends new ones, and the standard History Log cleanup functionality doesn't touch IAL data (it only cleans up history logs specifically). You have two practical options instead: switch the IAL to 'Copy All Data' mode and add your own 180-day cutoff condition directly into the IAL's own SQL statement, so old rows are never even copied into the target table in the first place; or keep 'Copy Only New Data' as-is and instead apply the 180-day condition wherever the IAL's data is actually being consumed (like in a Lobby or report query referencing it), filtering out old rows at read time rather than at the IAL's own storage level.

← Browse Developer Studio, deployment, and upgrades questions