Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
match data from other records in search
I need to search all customers and in the return include columns referencing data from contact and employee records.
Specifically, I have a field on the customer record that references the contact record and a field for salesrep. Pulling the field data from the customer I get the entityid and id from these fields. I need the email from the contact and employee records as well.
If I understand correctly, I can join using nlapiSearchColumn thusly: nlobjSearchColumn('id', 'contact'). However, how do I specify the contact record matching the id stored in the customer record's custom field?
Thank you.
Tagged:
0