|
|
Scrum for Team System - Feature Requests
Started by krismarkel at 05-02-2007 10:15 PM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 05-02-2007, 10:15 PM
|
krismarkel
Joined on 04-09-2007
Posts 1
|
Remove deleted SBIs from Sprint View report
|
|
|
|
|
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
|
|
|
|
|
Report
|
|
|
|
|
07-05-2007, 12:38 PM
|
cbrowning
Joined on 08-31-2006
Posts 29
|
Re: Remove deleted SBIs from Sprint View report
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
07-05-2007, 12:39 PM
|
cbrowning
Joined on 08-31-2006
Posts 29
|
Re: Remove deleted SBIs from Sprint View report
Attachment: Sprint_View.zip
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
07-16-2008, 4:25 PM
|
djk
Joined on 07-07-2008
Posts 25
|
Re: Remove deleted SBIs from Sprint View report
|
|
|
|
|
|
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.
|
|
|
|
|
Report
|
|
|
|
|
Scrum for Team ... » Scrum for Team ... » Scrum for Team ... » Re: Remove deleted SBIs from Sprint View report
|
|
|
|