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!
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]