Delete Workflow History!

Olá pessoal!

Atualizando o blog com materiais que estavam parados em meu one note!

O comando abaixo serve para limpar historico do workflow utilizando job no AX para garantir integridade e que não fiquem sujeiras!

delete_from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Completed &&

   WorkflowTrackingStatusTable.WorkflowType == WorkflowTrackingStatusWorkflowType::Workflow && WorkflowTrackingStatusTable.modifiedDateTime < DateTimeUtil::addMonths(DateTimeUtil::utcNow(),-3);

delete_from WorkflowTrackingStatusTable where WorkflowTrackingStatusTable.TrackingStatus == WorkflowTrackingStatus::Cancelled &&

   WorkflowTrackingStatusTable.WorkflowType == WorkflowTrackingStatusWorkflowType::Workflow && WorkflowTrackingStatusTable.modifiedDateTime < DateTimeUtil::addMonths(DateTimeUtil::utcNow(),-3);

Fonte: https://community.dynamics.com/ax/f/33/t/65699