Follow the steps below to create a workflow for archiving
SharePoint items in a separate list.
(For a more controlled archiving to a database we recommend
the kalmstrom.com Silver solution
In this example items with the status Closed in the Main
list gets copied to an Archive list and then deleted from
the Main list. The screenshots and the first demo below
shows SharePoint 2010, while the second demo shows SharePoint
Note that the version history is lost when you archive items
this way, so you should not archive until you know that
you don't need earlier versions.
Create a template from the Main list:
Then create a new list - the Archive list - built
on that template:
In SharePoint Designer, create a new workflow attached
to the Main list and set it to start automatically when
an item is changed.
Define the Conditions:
And the Actions:
If you wish to delete the ticket from the Main list,
define another action to do that:
Check the workflow, and Finish if it is ok.
Close a test ticket in the Main list. Then it should
show up in the Archive list. If you set an action to
delete the item, the ticket should also disappear from
the Main list.