This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I’ve added some contacts to a customer and set them to have different Contact Roles (some are native NetSuite Contact Roles, others are Contact Roles I’ve created).  How can I retrieve the contact(s) with a particular contact role for a particular customer either via SuiteQL or just regular old SuiteScript?  I tried this but it doesn’t return anything
```SELECT customerContactRole.*

FROM customer
JOIN customerContactRole
ON Customer.id = customerContactRole.entity

WHERE customer.id = 16802```

The records catalog shows a join between entity.id (or customer id) and contact.company

I’m talking about the contacts listed under the Relationships tab on a Customer

which could include people who work at other companies