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.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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.
Tagged:
0