Source of file WorkflowMigrationTask_LatestCompletedWorkflowRequestID.php
Size: 0,741 Bytes - Last Modified: 2021-12-23T10:28:49+00:00
/var/www/docs.ssmods.com/process/src/code/migrations/WorkflowMigrationTask_LatestCompletedWorkflowRequestID.php
1234567891011121314151617181920 | <?php class WorkflowMigrationTask_LatestCompletedWorkflowRequestID extends BuildTask { public function getTitle() { return 'Workflow LatestCompletedWorkflowRequestID'; } public function getDescription() { return 'Rebuild the LatestCompletedWorkflowRequestID on all pages'; } public function run($request) { DB::query("UPDATE SiteTree SET LatestCompletedWorkflowRequestID = (SELECT MAX(ID) FROM WorkflowRequest WHERE PageID = SiteTree.ID AND Status = 'Completed')"); DB::query("UPDATE SiteTree_Live SET LatestCompletedWorkflowRequestID = (SELECT MAX(ID) FROM WorkflowRequest WHERE PageID = SiteTree_Live.ID AND Status = 'Completed')"); echo "<p>Completed</p>"; } } |