Reporting on Stories and their dependencies

Spencer Granth1
Tera Contributor

Does anyone know how to report on the relationship of User stories and their dependencies/prerequisites? I've tried to create a list and show the related records but that did not work. 

2 REPLIES 2

Ehab Pilloor
Mega Sage

Hi @Spencer Granth1,

 

You would have to create database view of Story and dependencies/prerequisite tables and then you can produce report on it.

Refer these for more info:

https://www.youtube.com/watch?v=_JY462TmXxU

 

https://www.youtube.com/watch?v=syC8-0beVjQ

 

Regards,

Ehab Pilloor

In this ServiceNow Tutorial, Aaron Elder gives a demo on creating and using a database view in ServiceNow. Create the database view. Role required: admin. Learn more: https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/task/t_CreateADatabaseView.html ...
ServiceNow database views on reporting This interview is for up to 3 years experience candidate to touch how the questions will be raised and what the interview expects. #howto #workassignment #learningcoding #coding #servicenow #hiring #jobs #jobsearch #jobvacancy #jobvacancies #google #accenture

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Spencer Granth1 

I don’t think there’s a need to create any Database View. You can simply create a report on the m2m_story_dependencies table, and that should be sufficient.

The output will look like this:

 

DrAtulGLNG_0-1750949742812.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************