Published on July 14, 2021.

This morning I released the first beta of the NetSuite SuiteQL Query Tool v2021.2. This is something that I've been working on for several months, and I'm excited to finally be at a point where I can make it publicly available.

This version of the tool is significantly different from previous versions, and it's different in many ways.

The most noticeable difference is in the user interface. I'm now using Bootstrap, and in particular Bootstrap 4. I'm also using DataTables, a plug-in for the jQuery Javascript library that adds functionality to the tool's HTML tables. When viewing tables - whether it's the search results, lists of tables and queries, etc - you'll now see pagination options and a helpful search function.

But the most important changes to the tool are "under the hood."

If you've used earlier versions of the tool, then you might notice the tool's improved speed and overall performance. That's due in large part to a new approach that I've taken with this version of the tool. The tool is essentially a single page application. Once the tool is loaded, all of the calls back to NetSuite are made via XMLHttpRequests. As a result, there's no need for the page to be reloaded with each request, regardless of whether it's a request to run a query, load a file, etc.

But the most significant changes are the introduction of new features that allow you to specify the range of results that you want to have returned. You can now request specific ranges of rows that you want returned (such as "rows 1 through 25"), or request that all rows be returned. These new features allow you to go beyond the limitations of SuiteScript's "n/query" module and SuiteTalk REST's SuiteQL support. (That being said, please use the "return all rows" function with great care, as you can easily request a very large amount of data from NetSuite, and potentially bring your computer to a grinding halt.)

Other new features include a handy "Tables Reference" that you can use to locate tables and get information such as columns, joins, etc. There's a new "Remote Query Library," which is a shared cloud-based library of SuiteQL queries. And the original "Local Query Library" function has been improved as well, with improved functions for both loading and saving query files to and from a folder in the File Cabinet.

I'll cover more of these new features, and some of the other changes to the tool, in future blog posts and possibly as part of a webinar. In the meantime, here's a video that I put together to demonstrate the new version of the tool.

The SuiteQL Query Tool is still available free of charge. I'm releasing this version of the tool under an MIT License, and you can find the license in the script comments.

I'm planning to officially release the SuiteQL Query Tool v2021.2 early next week. In the meantime, if you'd like to experiment with the beta, please click here.

If you have any comments, questions, or suggestions about the tool, please post them to the SuiteQL channel over on the NetSuite Professionals Slack Community. If you'd like to contact me directly, click here.