How to get the "Incident Caused by Change" field value in Change table (List view)

[vinay babu abal]

I want to display the incident number(Change table (in List View)) associated with that particular change request. I can find that field in Incident table but i should find that field in Change Table. Please provide any suggestions

Actually i am creating the Change report(Type: display data in a list) for failed and successful changes and i am trying to capture that field

[vinay babu abal]

Actually i am creating the Change report(Type: display data in a list) for failed and successful changes and i am trying to capture that field

[Aman Kumar S]

Check my response below, only way you can achieve this is via database view 

[vinay babu abal]

that way.. can we create scheduled reports for that database view?

[Aman Kumar S]

@vinay babu abala 

Refer to below article to achieve the database view:

Database view between incident and change request tables

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂