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 Join for Unlisted Field
I am trying to perform a saved search that joins two related tables, but there is no option for the related fields in the Criteria fields (technically, I am using the Criteria tab on a Mass Delete, but should work like Saved Search). This is very basic in SQL = SELECT name FROM unitstype WHERE unitstype.internalid NOT IN (SELECT item.unitstype). This could also be handled with a basic outer join, but how do I accomplish this in NetSuite? My goal is that I am trying to delete any Units Type value that is not currently assigned to