What incident was used to create the Change request.

awyatt · ‎12-04-2017

The change request table doesn't seem to have a relationship with the incident table that will provide the incident that created the change(incident elevated to change not using a problem). And/or all incidents that will be solved by the change. I attempted to use the "related incident" field in the change request table. But it's null when even when there is an incident that will be solved by the change. I don't think I understand the tables and there columns. Is the a definition resource somewhere to explain the contents of the fields and there meanings or are we to just use the field name and schema map?

Thanks for any help

Alan

DrewW · ‎12-05-2017

A database view can involve more than two tables. In this case you simply need to create a database view between the change request and incident table that uses the Change field on the incident table to "join" to the sys_id field in the change request table. Make sure its a left join with the change request table on the left.

Create a database view

You can add as many tables as you want. just remember reference fields used to link to the table they point at use the sys_id column in the referenced table.

View solution in original post

DrewW · ‎12-05-2017

Are you looking for a report of all changes that are related to an incident or all changes and any incidents they may be related to? The first you can get with the relationship that is there. The second WILL require a database view that uses a left join.

awyatt · ‎12-05-2017

See my answer to Goran above.

Thanks for the help

Alan