Why CustomRecordCustomField Is Missing in SuiteQL
Diagnose why CustomRecordCustomField does not appear or query in SuiteQL: Records Catalog channel, role permissions, features and common false leads.
Debugging
7 notes in this thread.
Unexpected SuiteScript Error: Diagnostic Guide
Diagnose NetSuite UNEXPECTED_ERROR failures by isolating deployment, imports, permissions, field IDs, N/search, N/query, serialization and governance problems.
Find SuiteQL Table and Field Names
Use the NetSuite Records Catalog to find SuiteQL record, field and join IDs, understand role-specific availability and diagnose unknown identifier errors.
SuiteScript Standard vs Dynamic Mode Sublists
Choose the correct SuiteScript sublist APIs for standard and dynamic record modes, with working examples, field-sourcing differences and a debugging checklist.
SuiteScript Search Filter Expressions (AND, OR, NOT)
A practical guide to composing N/search filter expressions, including nested OR conditions, NOT, joined fields, formula filters and NetSuite special values.
SuiteQL Empty Strings Are NULL
A blank SuiteQL parameter is not equal to an empty string. Learn why optional filters silently remove every row, how to reproduce the problem, and two reliable ways to fix it.
Fix SuiteQL LISTAGG Invalid or Unsupported Search
LISTAGG is currently listed as unsupported in SuiteQL. Diagnose the generic error and replace string aggregation with grouped rows or JavaScript processing.