Welcome to Good Training Sign in | Become a member - FREE!
 

Purge Processes

Last post 03-15-2010, 9:59 AM by Adam Travers. 3 replies.
Sort Posts:
  •  03-12-2010, 10:42 AM 2335

    Purge Processes

    How can I delete a process?

    I want to purge a proccess with status "complete" but only for a particular date, not all "completed".

    How can I do this?

  •  03-12-2010, 10:48 AM 2336 in reply to 2335

    Re: Purge Processes

    Hi,

    Tools - Processes - Purge Processes (Enter Status Completed & Date Filter)

  •  03-15-2010, 9:52 AM 2340 in reply to 2336

    Re: Purge Processes

    What if i dont to purge all the processes for a particular date, only completed process for a particular contact in a particular date?
  •  03-15-2010, 9:59 AM 2341 in reply to 2340

    Re: Purge Processes

    In that case you would have to write a SQL Statement to delete the data:

    Example:

    DELETE FROM  PROCESS
    WHERE STATUS = - 100 AND
    TARGETID = 'Enter Contact ID' AND
    STARTDATE >= 'Enter Date' AND
    STARTDATE <= 'Enter Date'

     

     

View as RSS news feed in XML