How is "clean base rotation" determined?

bonsai
Mega Sage

How is the "clean base rotation" field set, which has a deadline for clearing tables in the "Table Rotation Group" feature, populated?

 

Table Rotation Group.JPG

 

It seems that the last table will store records until "2025-01-15 23:29:25".
When I checked the product documentation, I found the following.
It seems to be the date to clean the base table, but will the data of each table in the rotation group also be cleared?

I don't understand the meaning of the "clean base rotation" field or the rules for setting it...

------------------------------
The date to clean (truncate) the base table.
Applies to Rotation type.

4 REPLIES 4

Bert_c1
Kilo Patron

The documentation says:
Is this the date and time to clear all data from the table?
Or is it the date and time to clear the rotation table?

"The date to clean (truncate) the base table.
Applies to Rotation type."

GaominZ
Tera Contributor

@bonsai 
Hi, I am having the same question now. Have you found any answer wherelse ?
"It seems to be the date to clean the base table, but will the data of each table in the rotation group also be cleared?"

Finally, we found that the schedule for deleting the base table is set by business rules.

Also, the date displayed in the "Clean Base Rotation" field is set by the client script at the time of loading.

Don't trust the value displayed on the form. . Display the column on the list screen and check the value.

Also, "Clean up base table" is executed only once when rotation is set.

① A base table exists

② A rotation group is implemented on the table in ①
※ A value is set in the "Clean Base Rotation" field

③ The schedule for cleaning up the base table is set by business rules using the value of the "Clean Base Rotation" field.