How to Save SuiteQL Queries

Saving a SuiteQL Query is a built-in feature of Tim Dietrich’s SuiteQL Query Tool. Enabling this functionality requires a few simple customizations, including the creation of a folder in the File Cabinet and a minor edit to the SuiteQL Query Tool script. The steps to complete these tasks are outlined below.

More information from the source on SuiteQL Query Tool features (timdietrich.me):

The SuiteQL Query Tool also supports storing SuiteQL queries locally, in the NetSuite File Cabinet. (To enable this feature, simply create a folder in the File Cabinet, and grab its folder ID. Then update the "queryFolderID" variable in the SuiteQL Query Tool script.)

Enable SuiteQL Query Tool

Step 1: Create a new folder in the NetSuite File Cabinet: Documents > Files > File Cabinet > New.

Step 2: Access your new folder in the File Cabinet.

Step 3: Hover your mouse over the folder title.

Step 4: While hovering your mouse over the title, copy the number within the JavaScript indicator in the bottom left corner of the page. This is the folder’s internal ID. (Alternatively, you can edit the folder and find the internal ID in the URL.)

Step 5: Edit the SuiteQL Query Tool script.

Step 6: Paste the internal ID of the folder into the queryFolderID variable definition on line 80, as shown below.

Step 7: Now, when you write a SuiteQL query, you will have the option to save the query to a file in the folder you created. Simply select the Save button after writing a query and enter a title for the new file.

You can also load your saved queries to the SuiteQL Query tool by selecting the Local Library button within the SuiteQL Query Tool.

Related Articles

• Simple SuiteScript 1.0 Encryption | SS1

Got stuck on a step during this article?

We like to update our blogs and articles to make sure they help resolve any troubleshooting difficulties you are having. Sometimes, there is a related feature to enable or a field to fill out that we miss during the instructions. If this article didn't resolve the issue, please use the chat and let us know so that we can update this article!