Need to create Database View for merging two table LEFT OUTER JOIN

[ahmadfaiz]

I have two tables Story table(rm_story) and Change Request table(change_request).

to combine two table we have story.sys_id  = change_request.parent

Requirement is we need to show all the story when it has change request added or not. 

So that customer can we all the stories in that table and can check what are change request and what are all the Change task in that table.

[Brad Bowman · Accepted solution]

Try the setup like this:

[ahmadfaiz]

hi @Brad Bowman  ,

 I tried using this method, but problem here is, it is not showing all the story, instead it is only show stories which has Change request attached to it. I want to see all the stories in this table whether or not changes request is available or not.

[Brad Bowman]

Did you ensure that the Left join field is set to true for the second table that has the where clause?

[ahmadfaiz]

Yes, Because I have some stories assigned to me which I have not created any CR and those are not showing here