Connect Customer Account and Salesforce Opportunities using a related list

concept australia Updated Sep 10, 2026 1 min read csm-related-list-opportunity-table.md

Use a related list to link the Customer Account table with Salesforce Account Id, and the Salesforce Opportunity remote table with the same Account Id.

In this example, create a relationship called Opportunities. Choose the Account table in the Applies to table field and the remote opportunity table in the Queries from table field. For more information, see Create defined related lists.

[Omitted image "opportunities-relationship-table.jpg"] Alt text: Related list to create Opportunities relationship between the Account table and the Salesforce Opportunity table.

Add the following code in the Query with field:

JavaScript

(function refineQuery(current, parent) {
  var sf_account_id = new String(parent.u_salesforce_account_id);
  if (sf_account_id.length == 0)    sf_account_id = "undefined";
  current.addQuery("u_sf_account_id", sf_account_id);
})(current, parent);

This code checks for the presence of the Salesforce Account Id in the Account table and, if it's missing in the record, sets it to undefined. The code also includes a query for the Opportunity table column that holds the Salesforce Account Id for the value of this Id from the Account table. This query is invoked when the user opens the list of opportunities associated with the customer account. To see how it is used in the remote table script, see Selecting a spoke action and preparing the inputs.

Parent Topic:Using remote tables and the Salesforce spoke

41 lines · 2.7 KB Wrap lines

---
title: Connect Customer Account and Salesforce Opportunities using a related list
description: Use a related list to link the Customer Account table with Salesforce Account Id, and the Salesforce Opportunity remote table with the same Account Id.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/customer-service-management/csm-related-list-opportunity-table.html
release: australia
topic_type: concept
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Using remote tables and the Salesforce spoke, Reference Salesforce integration using remote tables, Third-party data integration for CSM, CRM Workspace features, CRM Workspace, Organize agent workspaces, Configure, Customer Service Management]
---

# Connect Customer Account and Salesforce Opportunities using a related list

Use a related list to link the Customer Account table with Salesforce Account Id, and the Salesforce Opportunity remote table with the same Account Id.

In this example, create a relationship called Opportunities. Choose the Account table in the **Applies to table** field and the remote opportunity table in the **Queries from table** field. For more information, see [Create defined related lists](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-user-interface/t_CreateDefinedRelatedLists.md).

\[Omitted image "opportunities-relationship-table.jpg"\] Alt text: Related list to create Opportunities relationship between the Account table and the Salesforce Opportunity table.

Add the following code in the **Query with** field:

```
(function refineQuery(current, parent) {

  var sf_account_id = new String(parent.u_salesforce_account_id);

  if (sf_account_id.length == 0)
    sf_account_id = "undefined";

  current.addQuery("u_sf_account_id", sf_account_id);

})(current, parent);

```

This code checks for the presence of the Salesforce Account Id in the Account table and, if it's missing in the record, sets it to `undefined`. The code also includes a query for the Opportunity table column that holds the Salesforce Account Id for the value of this Id from the Account table. This query is invoked when the user opens the list of opportunities associated with the customer account. To see how it is used in the remote table script, see [Selecting a spoke action and preparing the inputs](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/customer-service-management/csm-opportunity-table-script.md).

**Parent Topic:**[Using remote tables and the Salesforce spoke](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/customer-service-management/csm-integration-remote-tables.md)