Published on October 27, 2020.

An update to the SuiteQL Query Tool is now available. Learn more >

Back in August, I shared the first version of my SuiteQL Query Tool, a simple Suitelet that developers can use to query the backend database of a NetSuite instance via SuiteQL (SQL). I was surprised at the interest and feedback that I received, and pleased to learn that so many developers found the tool to be helpful.

Today I'm happy to share an updated version of the SuiteQL Query Tool. This new version adds functionality that developers have requested, and does so without adding any additional complexity to the interface. It's still provided as a single Suitelet, so installing it is very easy. And perhaps best of all, it's still available free of charge.

What's New?

Here are the new features and improvements to the tool.

Support for saving and loading scripts. You can now save and load scripts by storing them in the File Cabinet. To enable the save and load functions, simply add a folder named "SuiteQL Queries" to your File Cabinet.

Support for exporting query results. If your query is successful and results are returned, you can export the results as a Comma Separated Values (CSV) file.

Improved accuracy of query execution time calculation. The calculation that is used to determine the amount of time that a query took to run has been corrected, and as a result, it is more accurate.

Improved display of long column values. Longer text values (those exceeding 300 characters) are now truncated before being displayed in the results sublist. This prevents the Suitelet from terminating when this condition occurs. Note that the complete (untruncated) values are available via the export function.

Improved display of JSON-encoded results If the JSON-encoded representation of the result recordset exceeds 100,000 characters (a SuiteScript limitation), then only the first record is displayed. This makes it possible to access the column names, which can be helpful if you're using the tool to develop a query for use in an external solution.

Next Steps

If you're interested in the SuiteQL Query Tool, click here. You'll find links to download the Suitelet and additional SuiteQL-related resources, including tips and tricks, links to helpful blog posts, books, and more.

Thanks for your interest in the tool, and if you have any questions or comments, feel free to contact me.