MicroStrategy ONE
Purge Change Journaling statement
Purge change journaling transactions for all projects, the specified project, or the project source, based on the timestamp.
Copy
PURGE CHANGE JOURNALING BEFORE timestamp [COMMENTS "comment"] FOR (ALLPROJECTS
| PROJECT "project_name"
| CONFIGURATION);
where:
-
timestamp is the timestamp before which change journaling transactions will be purged, in the format MM/DD/YYYY hh:mm:ss.
-
COMMENTS "comment" is a comment to be included in the change journal for the purge, of type string.
-
ALLPROJECTS purges change journaling for all projects in the project source.
-
PROJECT "project_name" is the name of the project for which change journaling transactions are purged, of type string.
-
CONFIGURATION purges change journaling for the project source.
Example
Copy
PURGE CHANGE
JOURNALING BEFORE 01/01/2013 00:00:01 FOR PROJECT "Local Demonstration";