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!
Translate SQL into a search formula
All NetSuite experts,
Hope someone can give me some tips how I can script the formula in a customer search for the following issue.
A customer search already shows all of the customerID(A) who need certification.
then I need to join this search with the same customerID(B) on a custom record, with some extra criteria filtering the custom record.
Therefore, in SQL language is like:
Including all records from (A) and only those records from (B) where the join fields are on customerID, then (B).dateTime has to be after 2010.
Any examples and tips? Thanks