Download

Version 29.2.0

|

What’s Changed?

  • Roles: Added a Compare Roles button that opens the “Show Permission Differences Between Roles” page (Learn More)
  • Banking Import History: Added links to open the “Import Details” page (Learn More)
  • Added ID tooltips for buttons and field labels (Learn More)
  • SuiteQL Results:
    • When executing, the currently selected text is now automatically used as the query if any is selected (Learn More)
    • Added elapsed time for query execution (Learn More)
    • Added a “Records Catalog” link (Learn More)
    • Results in the format of recordtype:internalid and object_script_id are now clickable (Learn More)
    • Results with column names ending in “_html” get rendered as HTML (Learn More)
    • Allow aborting query execution (Learn More)
    • Added a Library button that loads Tim Dietrich‘s remote SuiteQL library (Learn More)
    • Added a Variables button to allow setting variables for the query (Learn More)
  • Map/Reduce Script Status details page: Auto enable Live View
  • Improve theming
  • Fix a NetSuite bug where the Edit button doesn’t work when accessing a Script Parameter record from the recent records list
  • Record links in Execution Log JSON wasn’t working for internal IDs if they were strings
  • Global search shortcuts: Searching for saved search and script deployment scriptids wasn’t working

Compare Roles Button

Easily compare the current role with one or more other roles

Banking Import History Details

See the following post by Marty Zigman for details on how this works: Gain Access to NetSuite’s Bank Import History Detail Page

Button ID and Field ID Tooltips

Execute Selected SuiteQL

Highlight part of your SuiteQL and click Execute to run just the selection

Clickable SuiteQL Results

If a result value is in the format of recordtype:internalid or object_script_id it will now be clickable

SuiteQL HTML Results

Simply use “_html” as the suffix for a column name to render it as HTML

Abort SuiteQL Execution

If a query is taking too long to complete, you can now end it early and start over

SuiteQL Library

Load SuiteQL examples provided by Tim Dietrich

SuiteQL Variables

  • Variable syntax is the same as JavaScript template literal syntax ${variable_name} to allow for easy copy/pasting of queries to and from SuiteScript
  • Variables named after SuiteScript Type enums automatically infer values such as:
    • ${record.Type.SALES_ORDER}
    • ${search.Type.ITEM}
    • ${query.Type.CUSTOMER}
  • Variables can optionally be saved as global for the current NetSuite account