Re: Remove deleted SBIs from Sprint View report

Scrum for Team System - Feature Requests

Remove deleted SBIs from Sprint View report

---

krismarkel 05-02-2007, 10:15 PM
I would like a way to filter out deleted SBIs from the Sprint View without having to import into Excel and delete them manually.

Thanks, and keep up the good work.
-k

Re: Remove deleted SBIs from Sprint View report

---

cbrowning 07-05-2007, 12:38 PM
Sorry I tried to upload the file and it didn't, so the file is attached in the next post.


I added the following clause to the select statement in the RDL file for the sprint view report which should fix your issue:
and w.system_id not in (
select distinct w.system_id
from [work item] w
where w.system_state = 'Deleted'
I am attaching the modified RDL files to this reply.

Re: Remove deleted SBIs from Sprint View report

---

cbrowning 07-05-2007, 12:39 PM
I added the following clause to the select statement in the RDL file for the sprint view report which should fix your issue:
and w.system_id not in (
select distinct w.system_id
from [work item] w
where w.system_state = 'Deleted'
I am attaching the modified RDL files to this reply.

Re: Remove deleted SBIs from Sprint View report

---

djk 07-16-2008, 4:25 PM
It would be nice if the filtering on deleted could be made optional with a checkbox

(great tool)

---

"Anything one man can imagine, other men can make real" - Jules Verne.