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!
Saved Search with 2 related tables
I am trying to figure how to search and show fields from 2 (or 3) related Types. In particular:
My client wants to find all 'Work order Issues' records that come in after 'Work order Completion' is created for that Work order.
I have been using the 'created from' (createdfrom) field to compare to a parent. But here I have 2 sibling types that I need to compare.
I would like to show in a single line the Document Ids of the Work order, Work order Issue and Work order Completion with created date for each.
But I am having trouble equating the Criteria and also getting to fields of each of the type of records.