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
Nenhum comentário:
Postar um comentário