The CreatorCon Call for Content is officially open! Get started here.

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]

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