SuiteQL Default Billing and Shipping Address
Return a customer default billing address, default shipping address or both with SuiteQL while retaining customers without an address.
SQL
5 notes in this thread.
SuiteQL GROUP BY Month, Quarter and Year
Group SuiteQL results by calendar month, quarter or year while keeping the output correctly sorted across multiple years.
SuiteQL Date Filters: Current and Previous Month
Filter SuiteQL records by the current month, previous month or a custom date range without losing rows at time boundaries.
SuiteQL EXTRACT(YEAR FROM): Year and Month
Use EXTRACT(YEAR FROM date) and EXTRACT(MONTH FROM date) in SuiteQL to filter, group and compare NetSuite date fields, with TO_CHAR alternatives.
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.