startDelete Historic Tasks
How To

Delete Historic Tasks

CCH Workflow
Last update: Reading time 2 minutes
Workflow Tasks
    Delete historic tasks, is available within the Workflow Management Console screen, allowing users the ability to delete historic multi action tasks and tasks that require the selection of an employee for the workflows that were completed, cancelled, aborted or terminated.

    Details

    The historic tasks that are deleted using this option are the tasks that were not selected during the progression of a workflow. E.g.  If a workflow has a Pass/Fail step, and the user chooses to progress the step by selecting the Pass branch, a record will be stored in the dbo.ActivityAction table for the Fail branch as well. The same is for the tasks that require the selection of an employee to be progressed: even though a single employee is assigned to the task, records are added in the dbo.ActivityAction table for each employee from the list of employees that are eligible to be assigned to that step. In time, the size of the database can grow considerably causing performance issues, so the purpose of the Delete historic tasks option is to delete from the dbo.ActivityAction table unnecessary records.

    To delete the historic tasks, open the Workflow Management Console screen then click on the Delete historic tasks option from the Actions section within the ribbon:

    clipboard_e7b40b1cabcfef2564691e8a0e5d4e6fc.png

    If there are items that can be deleted, the following dialog is displayed indicating the number of items that can be removed from the dbo.Activity Action table and the user that last ran the deletion routine and the date when the deletion routine was last performed.

    clipboard_ef0a8958e53f3ad6bb364702819419f46.png

    Note: The historic multi action tasks and tasks that require employee selection can be deleted only for completed, cancelled or terminated workflows.

    If there are no items that can be removed from the dbo.ActivityAction table, then the following dialog is displayed:

    clipboard_e37de1de87b36afe7a37dc5608abf6790.png

    Considerations

    Where a large number of items are returned as available for deletion, it is recommended to perform this routine out of hours. 

    It is also recommended after running the deletion for a large number of items, that the Database maintenance routines are run.

    Related documents

    CCH Workflow 2025.3: Release Notes
    The document provides release notes for CCH Workflow version 2025.3, highlighting installation prerequisites through the Central Suite Installer and introducing a new configuration key, Wf_DocumentExtraFields, which enables the merging of document extra fields. Firms wishing to disable this feature can adjust the key value. It includes legal disclaimers regarding accuracy and confidentiality, as well as trademark information. The content is proprietary to Wolters Kluwer (UK) Limited and is not to be reproduced without permission.
    VAT Workflow : Quick Start Guide
    This document serves as a comprehensive guide for managing VAT returns using the CCH Central Workflow system. It details the steps for creating a customized VAT workflow by saving the standard workflow as a practice-specific version, updating assignment responsibilities, and setting up VAT assignments and jobs. The guide covers the process for adding workflows to clients, customizing the homepage for workflow management, and tracking tasks within the workflow system. Additionally, it highlights automation features for task assignment and periodic workflow creation with links to further resources for detailed instructions.
    Progressing the tasks
    This document outlines the process for managing workflow tasks. Users can complete tasks via the Tasks homepage by selecting their names and using the ribbon bar for options like "Mark as complete." Multiple simple tasks can be completed in bulk. Tasks can also be reassigned to different employees, or specific employees can be selected for subsequent workflow steps. The document includes images to illustrate these procedures.
    Progressing workflows
    This document provides instructions on progressing tasks within a workflow homepage, detailing actions such as completing milestones, selecting outcomes, passing or failing tasks, and selecting employees. Users are guided on how to navigate the interface, including right-click options to manage tasks effectively. The document also mentions non-milestone tasks, directing users on how to reveal these tasks and proceed with their completion. Additionally, it highlights the ability to add comments to choices made within the workflow.
    Introduction to the Workflow homepage control
    The document provides an overview of the Workflow homepage control, detailing its functionality for monitoring workflow progression. It covers how to customize the interface, select workflows, and change view options, including due dates and employee views. The document also highlights the use of the "Field Chooser" for adding relevant columns, adjusting totals displayed for workflow steps, adding or editing comments, and applying filters to streamline the displayed workflows. Visual aids and step-by-step instructions complement the descriptions for ease of use.