I need a report that shows all Stories and stand-along Defects in an SDLC Release. We are in Geneva without the Analytics module. I want a list view of the stories and defect to create a visual task board.

[danamiller]

I need a report that shows all Stories and stand-along Defects in an SDLC Release. We are in Geneva without the Analytics module. I want a list view of the stories and defect to create a visual task board.

[Erich Zirnhelt]

Since Defects and Stories are both extensions of Tasks, you could use the task_list to isolate those objects in a single list view, like this:

https://<instance>.service-now.com/task_list.do?

sysparm_query=active%3Dtrue%5Esys_class_name%3Drm_defect%5EORsys_class_name

%3Drm_story&sysparm_first_row=1&sysparm_view=

To isolate for your release, dot-walk through the Parent, Task Type = Release:

https://<instance>.service-now.com/task_list.do?

sysparm_query=active%3Dtrue%5Esys_class_name%3Drm_defect%5EORsys_class_name

%3Drm_story%5Eparent.sys_class_name%3Drm_release

If you have many releases, this will group by them:

https://<instance>.service-now.com/task_list.do?

sysparm_query=active%3Dtrue%5Esys_class_name%3Drm_defect%5EORsys_class_name

%3Drm_story%5Eparent.sys_class_name%3Drm_release

%5EGROUPBYparent&sysparm_first_row=1&sysparm_view=

Once you add the final filter to isolate the one release, it should be easy enough to generate the VTB.

Note - there will be a lot of State lanes, pulling from across all the various Task Types. Use the VTB Configuration to hide those you won't be needing for Stories and Defects.

[Erich Zirnhelt]

I added carriage-returns to the URLs I shared to make them more legible.

[danamiller]

Thanks Erich, That works. I need to do some configuration but now I can show that it is possible.   Saved the Day!