Can we show the related list records of one table into another table.

[prashantA18]

What I want is in problem table while creating the problem record there is one custom field Parent Incident which is referenced to Incident table.When I select the Incident record in the Parent Incident field and save the problem record then in related list of that problem record child incidents should be shown of that record selected in parent incident field.

[Community Alums]

Hi @prashantA18 ,

Please follow the below links :

https://www.servicenow.com/community/developer-articles/servicenow-create-custom-related-list-servic...

https://www.servicenow.com/community/itsm-forum/how-to-move-one-table-of-related-list-records-into-a...

[Ankur Bawiskar]

@prashantA18 

you will have to create a defined relationship and use scripting in this table when you create new "sys_relationship"

Something like this

(function refineQuery(current, parent) {

    // Add your code here, such as current.addQuery(field, value);
    var parentIncident = parent.parent;
    var arr = [];
    var gr = new GlideRecord("incident");
    gr.addEncodedQuery("parent_incident=" + parentIncident + "^ORparent=" + parentIncident);
    gr.query();
    while (gr.next()) {
        arr.push(gr.getUniqueValue());
    }
    current.addQuery('sys_id', 'IN', arr.toString());

})(current, parent);

Then save this and add this related list on Problem Form in Your View -> Configure Related Lists

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

[Ankur Bawiskar · Accepted solution]

@prashantA18 

Hope you are doing good.

Did my reply answer your question?

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