I’m trying to find role names for Customer Contact...
# ask-stanley-ai
t
I’m trying to find role names for Customer Contacts in SuiteAnalytics Connect in the Netsuite2.com schema - what table would that be in?
c
AI generated answer (using internal Slack threads):
In SuiteAnalytics Connect, the role names for Customer Contacts can be found in the
customerContactRole
table. You can retrieve the contact(s) with a particular contact role for a particular customer via SuiteQL or SuiteScript. Here is an example of a SuiteQL query:
Copy code
sql
SELECT customerContactRole.*
FROM customer
JOIN customerContactRole
ON Customer.id = customerContactRole.entity
WHERE customer.id = 16802
Please replace
16802
with the actual customer id you are interested in. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.849969447
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828939855
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821416378
Please provide your feedback on this answer.