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

Steven G_ · ‎12-04-2017

Hi Alan,

you need to make a one to many relationship in order for them to come up on a related list, please follow this doc https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/administer/task-table/task/t_De...

Define a task relationship allowed from the task relationship type record

awyatt · ‎12-04-2017

Thanks for helping. But my issue in creating a relationship is I don't know what field to create the relationship with.

The "incident" table has a field "change request" which allows me to pull all incidents and there associated change request.

But what i need to do is pull all change request with there associated incidents. But I can't, as the change request table doesn't have a field for the incident that it was created from or the incidents that will be solved when it is implemented. Looking to create a change request report with associated incidents.

Thanks again

Alan

Steven G_ · ‎12-04-2017

Hi Alan,

simple create a field on the change record, name it source of change and you should be good. We have one on our CR and we point it to the task table to have the association accross multiple record types.

DrewW · ‎12-04-2017

Have you reviewed the code that is called to create the incident to see what field is used if any?

Also I have been asking ServiceNow for list of all the fields for each table and what they are intended for for many years now, so if you get something please post it. So if you cannot find something in the documentation for the form then you are left to what you can deduce.