SuiteQL Edit Column Name to Make It More Readable
If you're using Tim Diedrich's SuiteQL suitelet in your Netsuite instance to generate a table of results and want to present this result but don't like the column headers, or if yo…
SuiteQL
6 notes in this thread.
SuiteQL Generate Numbers from 1 to N Using DUAL
There are times when I want to generate a list of numbers from 1 to n in Netsuite and it usually involves dates. For example, if I wanted to calculate the number of actual work day…
SuiteQL: My Default Query Template
When creating a SuiteQL query in SuiteScript I'm finding my query starts with the following structure: What I'm finding with my SuiteQL queries is that I want to place all my input…
SuiteQL: Query To Get Customer Address Details
If you're using SuiteQL to obtain a listing of Customers and their subsequent addresses the following query may be most handy: This query contains the following details: The DISTIN…
Suitescript: LISTAGG Invalid or Unsupported Search Error SOLVED
The LISTAGG is an aggregate function that is a great way to group fields into a string field, usually by concatenating the results of these fields. However, when using this functio…
SuiteQL Improve Budget Query With CTE
I recently ran a budget SuiteQL query that took a whopping 527,138ms to complete that's nearly 9 minutes!. I had to take a look and see why it was taking so long, and after a few t…