Moving tasks - anyone any suggestions?

jamespate

I want to be able to move completed tasks from a "live" list to an "archive" list. Any suggestions for a neat way of doing it?

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

We use task lists to track action items, and created a LiveReport to separate "live" tasks from completed or cancelled tasks. The report keys on the task list ID, so you can set it for one task list or several. Here is a copy of the SQL (for Oracle):select DTree.*, KUAF.Name as kuafname, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'On Hold') as mystatus from DTree, KUAF where (SubType=206) and (KUAF.ID=DTree.Assignedto) and ((DTree.Status=0) or (DTree.Status=1) or (DTree.Status=2) or (DTree.Status=3)) and (DTree.OwnerID=957917 or Dtree.OwnerID=144193) and %1 order by DTree.DateDue%1 is filter by permissions.This approach allows you to separate "live" from "archived" tasks (you could write a matching report to pull completed or cancelled tasks) without changing anything in the database. If you really wanted to move tasks from one list to another, you would need to go into the database and change the parent ID of the task --not hard to do, but the LiveReport approach is easier.