@Ramesh1532 To fulfill this requirement in ServiceNow, you can use a Script Include that queries both tables (contact and your custom relationship table) and returns a combined result.
Script Include will look like below and feel free to modify as needed:
var CustomContactLookup = Class.create();
CustomContactLookup.prototype = {
initialize: function () {},
getCombinedContacts: function () {
var result = [];
// Query the 'contact' table
var contactGR = new GlideRecord('contact');
contactGR.query();
while (contactGR.next()) {
result.push({
sys_id: contactGR.getValue('sys_id'),
name: contactGR.getValue('name'), // Update the field names as per your table
});
}
// Query the custom relationship table
var relationshipGR = new GlideRecord('your_custom_relationship_table');
relationshipGR.query();
while (relationshipGR.next()) {
result.push({
sys_id: relationshipGR.getValue('sys_id'),
name: relationshipGR.getValue('related_name'), // Update the field names as per your table
});
}
return result;
},
type: 'CustomContactLookup'
};
Hope this will help you.
