trafalger
09/30/2024, 6:34 PMCeligo AI
09/30/2024, 6:34 PMAI 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:
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.
******Celigo AI
09/30/2024, 6:34 PMSlack 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
Celigo AI
09/30/2024, 6:34 PM