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

[suvro]

You cannot get that directly because in change record there is no  field storing the reference of that incident.

But you can create a database view using incident and change table where incident caused by change = sys_id of the change.

Use that view to report

[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

[suvro]

Creating Database view is the only option

Refer to below article to achieve the database view:

Database view between incident and change request tables

[Aman Kumar S]

Hey,

Its not technically possible to have the same field on the change request list, since that field is present on the incident form, you can only have those information on the incident list.

Although, you can create a Database view for incident and change to show the columns on your form.

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

Will be helpful for future visitors looking for similar questions 🙂