Master the Foundation of Querying in SuiteScript

NetSuite's Workbook functionality exposes the most powerful, flexible, useful Analytics the platform can provide. In order to build these Workbooks, you must have a solid foundation of knowledge on SuiteScript's querying capabilities.

Basic Querying in SuiteScript is intended to help you build that solid foundation through realistic, functional examples utilizing SuiteScript 2.0's N/query module.


Chapter 1: The Anatomy of a SuiteScript Query

Example: Who are our Individual Customers?

You'll learn:

  • The basic formula for querying with the SuiteScript API and its N/query module
  • How to create a new Query with simple Conditions and Columns
  • How to execute a Query and iterate over its Results
  • How to read values from a Query Result

Chapter 2: A More Concise Query

Example: Who are our Individual Customers? (the short version)

You'll learn:

  • How to define much more concise, readable Columns
  • How to condense the Result data structure for easier parsing and manipulation

Chapter 3: How Many Results Does My Query Have?

Example: How many Individual Customers are there?

You'll learn:

  • How to count the number of results a specific Query will return

Chapter 4: Multiple Query Conditions

Example: Which Customers for a specific Sales Rep have an Overdue Balance?

You'll learn:

  • How to combine multiple Conditions with logical relationships
  • A pattern for isolating the definition of a Query from how its Results are processed

Chapter 5: Retrieving Data from Related Records

Example: ​What is the Email Address of the Primary Contact on each matching Customer record?

You'll learn:

  • How to retrieve data from Related Records by using Join Columns
  • How to filter based on data from Related Records using Join Conditions

Chapter 6: Sorting Query Results

Example: Which Customers have the highest Overdue Balance?

You'll learn:

  • How to sort Query results on multiple Columns
  • How to set the direction of a Sort
  • How to specify the case-sensitivity of a Sort
  • How to handle empty or null values with a Sort

Chapter 7: Loading and Executing a Workbook

Example: Loading and executing an existing Workbook

You'll learn:

  • How to load and execute an existing Workbook from SuiteScript

My Insta-Refund Guarantee

If you are less than 100% satisfied with your purchase and email me saying so, I will immediately click the Refund button and return 100% of your money, no questions asked.

Questions? Still not sure?

Email me with your questions or concerns, and I'll reply directly. I'll also send you a sample chapter.​