I want to run suiteQL in Netsuite

1. https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/

I read the article but there’s no guide for installing the page.

Can I know how to show the page in my Netsuite?


2. When I query the custom-field in systemNote, 

If the context of the field is Map/Reduce, I couldn’t find it.

I think Netsuite only saves the result in the context of CSV or Netsuite’s item itself.


But, I want to query the historical data of the systemNote of an item.

Rookie Asked on September 29, 2023 in SuiteScript.
Add Comment
1 Answer(s)

You will have to take the script file labeled suiteql-query-tool.v****.suitelet.js and use it to create a new script record.

  1. Navigate to customization > scripting > scripts > new
  2. Click the + button next to the file field
  3. Select your suiteql-query-tool.versionnum.suitelet.js file
  4. click save
  5. click create script record
  6. Name your script
  7. Click Save
  8. Click deploy script
  9. Switch the status of the script deployment to ‘Released’
  10. Under the audience tab, select all rolls and all employees
  11. Save the script deployment
  12. Click the generated link on the script deployment record

That link will take you to the query page where you can run suiteql in a UI

Rookie Answered on September 29, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor