AnsweredAssumed Answered

save only last 10 days of data in sql database

Question asked by bladimir on Apr 15, 2020

I have created a Asset view to save the last 30 days of some attributes into a SQL server database.

The view refreshes data every day, but keeps accumulating data from more than 30 days old.

I only want to get and save to the database data from last 30 days, delete any data older than that and refresh the SQL database.

How can I create the view that will do this? Is it possible?