Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Multi-Table joins
Is it possible using SuiteScript to do a multi-table (Multi-Record Type) join in one nlapiSearchRecord call using custom record types?
I have three custom record types that I need to combine in one search to get a data set needed for a script. The three record types are cascading so record type 1 is the parent of record type 2 and record type 2 is the parent of record type 3. The search filter criteria is on a field in record type 2. I can't figure out a way of doing a query like this. Is this even possible?