Requirement to show Epic & Feature Parent Record of Scrum (Database View)

samuelbingham
Tera Contributor

Hello all, I am trying to show the parents of sn_safe_scrum_task records. These scrum tasks have parent records that could be an epic or a feature. I tried to do a database view, and it worked when the feature table was the only other table I added. Then when adding the epic table and an "or" condition in the where clause for the scrum tasks, it was not working. Is this possible to do? Because eventually I have to add the metric definition to show the duration of the scrum tasks in each state for reporting purposes. That is why I am trying to do a database view. 

DatabaseView1.pngDatabaseView2.png

4 REPLIES 4

WillieW
Tera Contributor

The order values should be different. 100: scrum, 200: epic, 300: feat1. based on your Where clauses.

jcmings
Mega Sage

Not the best with these WHERE clauses, but should you be using _parent and _sys_id rather than .parent and .sys_id?

WillieW
Tera Contributor

The where clauses should be moved to the 2nd and 3rd table in your list. And I do not see any "." in the screenshots.

 

Please review existing OOB database views in your instance to see how they are defined.

Hello, I followed a video on youtube and fixed where clauses and the following issues. I also figured out how to satisfy my requirement. Thank you for your help.