database view to join change and outage table

[Gaurav Vaze]

Hello all
I have a requirement of creating a report on a database view which comprises of fields from change (change_request) and outage table (cmsb_ci_outage)
I was able to create a database view but when I try to create a report on that I do not get the fields in filtering condition
I'm not sure if my WHERE clauses are right
I have left the WHERE clause as blank in the change table
while  for the outage table the where clause is as follows

I am new to database views so any help will be appreciated

[Community Alums]

Hi @Gaurav Vaze ,

You can try with task sys id as the primary key over task number.

[Jitendra Diwak1]

Hi @Gaurav Vaze,

Your database is correct and as checked, you do not have record in Outage table associated with Change. for testing purpose, you could pick record in outage table from Change table and save it then you will get one record. And there is field on View tables is Left Join false means it will show only those record are associated with Change record in Outage table and if it is true then it show all record from both table.

Please accept my solution if it works for you and thumps up.

Thanks

Jitendra

[Jitendra Diwak1]

Hi @Gaurav Vaze,

Did my solution helped you?

Please accept my solution if it works for you and thumps up.

Thanks

Jitendra