Deleted tasks appear in export to Excel

L

Leo

After publishing a project, I deleted some of the tasks in the project and
published again. The deleted tasks still show up in the assignment view in
resource center, though with an X in front of it. When I export the data to
Excel the deleted tasks show up in Excel. I have not been able to filter out
the deleted tasks. Also, I can not filter out the deleted tasks in Excel
since the field containing the X doesn't come accross. Of course I can ask
all resources to hide the deleted tasks in their timesheets, but given the
number of resources this is not a viable solution. Any suggestion how I can
filter the deleted tasks out?
 
D

D Web

Leo,

This sql update query should do the trick for you, effectively hiding all
the deleted tasks:

Update MSP_WEB_ASSIGNMENTS Set WASSN_REMOVED_BY_RESOURCE = 1 Where
WASSN_DELETED_IN_PROJ = 1

D Web
 
L

Leo

Thanks for the suggestion, but deleting the tasks in the back-end is a batch
process. I still run the risk that a task is deleted and downloaded to excel
between 2 runs. Filtering them out is the best option. If this is not
possible, is there a way to automatically schedule your query. If I run it
every 5 minutes, it will reduce the risk significantly.
 
Top