Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Searching customer record to obtain primary contact
Maybe I'm missing something, but I want to do a search that returns both the specific customer record plus the primary contact information based on a known customer record ID.
Seems the only information regarding the primary contact is the text-based 'primarycontact' field which is not searchable for a unique primary record (could be redundant).
a) I know there is an undocumented field in the contact records called 'contactrole' which can be set to -10 to set it as the primary role contact. There does not seem to be a join ability with primary contact (would be nice for something like returnColumn('phone','primarycontact') ), but is it possible to do a sub-search that filtered on company ID and 'contactrole', or is this unsupported. I ask because 'contactrole' is not listed in the documentation and do not want to create an unsupported search.