How to create a database view between story table and scrum task table?

[BijoyDeb]

Hi All,

I was trying to create database view between below tables for reporting purpose-

1. Story

2. Scrum task (story might have multiple tasks)

3. Defect (Story might have multiple defects)

4. Change request (Story has one change request)

I added all these tables in view tables, but when I try them I can see scrum task number or defect number as empty in view fields on list

Can someone please help me with conditions, left joints etc

[Ankur Bawiskar]

@BijoyDeb 

if each of those tables are related with each other in some or the other way then database view can be created.

what did you create and what's not working? share screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.