Does anyone know of something like Tim's SuiteQL t...
# suitescript
c
Does anyone know of something like Tim's SuiteQL tool, but meant for end-users? Ideally something that will just launch a desired report, or we can link directly to a results view for users to favorite.
b
If the goal is to give end users a simple click-and-view experience, I would probably not expose a SuiteQL tool directly. SuiteQL is more developer-focused. I would recommend SuiteAnalytics Workbook or Saved Search because it keeps the SQL hidden and provides a native NetSuite experience.
c
Yeah that's the goal. Was wondering if someone has made something sql focused for reporting? Sometimes it's just easier/quicker to write a query (especially for sub queries) for some reports.
b
For more complex reporting, especially when you need subqueries, CTE-style logic, multiple joins, or calculations across different records, SuiteQL is often much faster to build than trying to force everything through Saved Search criteria/formulas. I havenโ€™t seen a widely adopted native end-user SuiteQL reporting tool from NetSuite itself. I usually solve it this way. Custom Suitelet reporting page โ†’ store/manage SuiteQL queries behind the scenes and provide users with a simple report launcher.
a
I design reports using suiteql in suitelet, and show results in bootstrap data table
s
s
You could look into NimbusQL. They added a Reports function that is just a button to execute a query, without having to see the query itself.
m
I've used Tim's tool effectively by setting the deployment to current role for security, and then saving queries locally for the team. If you haven't set up a local saved queries location, you should - makes a world of difference.
c
@Shannon Thanks. After a bit of work I was able to get it compiling (had to fix the utils file).
๐Ÿ‘ 1
c
I've been thinking about building another jetbrains plugin that lets you query from right in the IDE. Dunno if anyone else would use it? I think it would be a super helpful addition to the official plugin but not sure how willing the team is to do it (or if they can). I know you could use postman to just query but having json results isn't great for visualizing.
๐Ÿ‘ 1
c
Datagrip support would be cool if you could get it working without the ado connection license.