What’s Changed?
- SuiteAdvanced menu: Added “Run SuiteQL” option (Learn More)
- Custom Roles: Added an Export All button to export all permissions to a CSV file (Learn More)
- “Search in NetSuite” context menu and Omnibox search (with “ns”
tab): Added support for the following:- URL paths such as
/app/common/custom/custrecordentry.nl?id=123 - Object scriptids such as
customrecord_my_record - Record and saved search IDs such as
customer:123andsearch:123 - Run SuiteQL such as
SELECT * FROM customer(Learn More)
- URL paths such as
- Records Catalog: Added a Run Sample Query link to query the current table for the first 30 results (Learn More)
- Manage Translations page: When creating a new string, the Collection dropdown now defaults to the currently filtered Collection (Learn More)
- Disable floating bottom buttons if there’s not enough vertical space
- Dark mode and theming improvements
Export Role Permissions
It can be challenging to compare roles in NetSuite, but it’s easy to compare data in Excel.
Run SuiteQL
There’s a new option under the SuiteAdvanced menu called “Run SuiteQL”.
It opens a page where you can execute SuiteQL and see the results.
Buttons are displayed at the top. They each have tooltips to help you remember what they do.
- Execute – Run the SuiteQL
Ctrl or Cmd + E - Clone – Run the current SuiteQL in a new tab
Ctrl or Cmd + D - New – Open a new empty tab of the SuiteQL Results page
Ctrl or Cmd + O - Export – Export the current results as a CSV file
Ctrl or Cmd + S
There are a few other methods for getting to this page.
1. Enter SuiteQL into the NetSuite global search
2. Enter SuiteQL into the the URL bar
- In your browser’s URL bar (called the “omnibox” in Chrome)
- Type “ns” and then hit Tab, which should show “SuiteAdvanced”
- Type a SuiteQL query or anything else you’d like to search in NetSuite
- Hit the Enter key
3. Use the “Search in NetSuite” context menu
This can be especially useful when reviewing a SuiteScript file and checking what a snippet of SuiteQL does.
Run Sample Query
So often I’m browsing the NetSuite Records Catalog, and I come across a table I’m unfamiliar with. Now it’s easy to run a sample query to see what kind of data the table holds.
The sample query selects all columns of the first 30 results. You can modify your query as needed.
New Translation String: Default Collection
The Problem: When managing translations in NetSuite (Customization → Translations → Manage Translations), you can filter the list of translation strings by Collection, but when you use the Create New button, the Collection field in the modal window doesn’t default to the one you were filtering by. It can be very time consuming to set the Collection for each new string.
With this version of SuiteAdvanced, it now defaults to the Collection you were filtering by.
