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.
SuiteScript excluding records of a saved search
Hello,
Is it possible to write a script that will look at the results of a saved search and exclude customers found in that search? The following sql is what I am trying to achieve in SuiteScript and so far I have not seen anything that indicates it is possible.
Select
CustomerID, ActivityID
From Activities
Where CustomerID NOT IN
(
Select
CustomerID
FROM Activities
WHERE ActivityType = ‘PhoneCall’ and Status = ‘Completed’
) calls
[FONT=arial]Essentially, the above will be created as another saved search that is accessible in NetSuite.[/FONT]
0