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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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?
0