Database view

[Nandhinisri]

Hi

I want to create a database view for incident and related changes. How can I achieve that?

[Dr Atul G- LNG]

Hi @Nandhinisri 

Do you mean the change in the related list?
What exactly is your use case? Because this can also be achieved without using a database view, like this...

[Ankur Bawiskar]

@Nandhinisri 

incident already has fields to store related CHG

What's your actual business requirement to create database view?

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

[Bhuvan]

@Nandhinisri 

If you are looking for incidents and related changes using incident table field 'caused_by' relation, configure database view using below. If your requirement is different, alter the where clause accordingly

Change table, prefix chg with order of 100

Incident table, prefix inc with order of 200 and Where clause is inc_caused_by=chg_sys_id

Below is a sample database view for reference

Please note if your requirement is to only show incident and change relation in a dashboard or report, you do not need to create database view as this would make sense only if you are combining multiple tables in a view that is not available out of box.

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan