Dear IFS experts,
I have created an IAL which copies only new data.
What happen with all these entries which are older than 180 days?
Will they be deleted after180 days automaitcally?
If not how can I reach this?
Solved
Clear history logs from IAL automatcally
+23Best answer by Tomas Ruderfelt
When “Copy Only New Data” in IAL is used you get a table created where the data from your SQL statement is stored. When you schedule this to run for example once a day only new records will be added to the table.
The IAL concept has no logic to remove records older than x number of days.
History logging cleanup is only removing history logs nothing else.
Now to your question about how to get only 180 days of data to be shown in IAL.
You can go for option “Copy All Data” and add the 180 days condition in your SQL statement.
Or you can keep it like it is and add a condition on 180 days when you use the IAL.
When “Copy Only New Data” in IAL is used you get a table created where the data from your SQL statement is stored. When you schedule this to run for example once a day only new records will be added to the table.
The IAL concept has no logic to remove records older than x number of days.
History logging cleanup is only removing history logs nothing else.
Now to your question about how to get only 180 days of data to be shown in IAL.
You can go for option “Copy All Data” and add the 180 days condition in your SQL statement.
Or you can keep it like it is and add a condition on 180 days when you use the IAL.
+23Hi
I suspected it.
Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.