Requirement to show Epic & Feature Parent Record of Scrum (Database View)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 11:36 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 12:02 PM
The order values should be different. 100: scrum, 200: epic, 300: feat1. based on your Where clauses.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 01:11 PM
Not the best with these WHERE clauses, but should you be using _parent and _sys_id rather than .parent and .sys_id?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 01:34 PM - edited ‎07-15-2025 01:36 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 01:37 PM
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.