This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

does anybody know if there is any visual interface for testing SuiteQL within NS? I mean to test the actual Query and how to get there?

Try <https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/|this> from <@U856E2SEA>

Here is a buggier version that has some neat features like auto formatting with ctrl-shift-f

SQLSuitelet 2.js

someone should make this using real web app tools rather than a UI suitelet.

Yes. In our case we prefer Angular, I know some folk prefer React. Point is, a rich client app would be ideal for doing a lightweight SuiteQL development environment.

rich intellisense, ability to save/load code snippets, refactoring, interactive paging, local sorting or filtering/mapping results. list goes on and on. Basically the things other tools like SSMS or other SQL tools have.

<https://nimbuslabs.com/nimbusql/> has some of these features <@UHG6BMGQ3>

Thanks <@U29QCJQF3> 

<@U02QAQB104D>  feel free to install the bundle using the instructions on the page Michoel linked. This has some of the features you mentioning, adding support for variables shortly.

Let me know if any questions. 

is the product UI  Suitelet based? <@UHG6BMGQ3>?

It doesn't actually use any NetSuite form/field elements, all custom HTML, just uses the suitelet as the rendering engine

OK, that sounds a bit more tolerable :slightly_smiling_face: