🎯 Learning Objectives
- Write SuiteQL queries with N/query module
- Navigate the Records Catalog for schema discovery
- Create and execute searches with N/search
- Understand when to use query vs search
- Work with joins for related data
- Handle large result sets with pagination
📖 Modules
7
N/query Module (SuiteQL)
SQL-like queries with runSuiteQL(), pagination with runSuiteQLPaged(), Records Catalog navigation, and joins.
8
N/search Module
Creating searches programmatically, loading saved searches, filters, columns, joins, and iterating results.
🔑 Key Concepts This Week
SuiteQL
SQL-like query language for NetSuite
Records Catalog
Schema browser for table/field discovery
runSuiteQL()
Execute query, 5000 result limit
search.create()
Build dynamic searches in code
Joins
Link related records in queries
Pagination
Handle large result sets efficiently