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";