https://netsuiteprofessionals.com logo
m

Matt Bernstein

04/15/2022, 2:56 PM
If anybody is looking for a suiteql editor that has code completion, Anyone can download via bundle with the id 422483 (SuiteQL Monaco Editor). You can also save sql files to the filecabinet to rerun and export. The editor is the monaco editor, which is the same one that powers vscode.
s

Shawn Talbert

04/15/2022, 3:24 PM
open source?
m

Matt Bernstein

04/15/2022, 3:25 PM
I haven't made it open source yet but will in the future
s

Shawn Talbert

04/15/2022, 4:06 PM
great to see some innovation in the SuiteQL space
c

Cory Weiner

04/18/2022, 6:49 PM
Nice I’ve been building something similar…
message has been deleted
m

Matt Bernstein

04/18/2022, 7:04 PM
that looks really good! I like the actual files. Which editor are you using? The code completion has really been a life saver when building out new queries for scripts
c

Cory Weiner

04/18/2022, 7:06 PM
I originally used Monaco but switched to codemirror as I found it a bit easier to customize as I wanted.
m

Matt Bernstein

04/18/2022, 7:09 PM
Yeah it's a bit tough. I had to kind of do my own code completion logic but it also allows for easy keyboard shortcuts which I do really like
c

Cory Weiner

04/18/2022, 7:10 PM
Nice I will download and give it a try
a

Alan Fitch

04/19/2022, 4:38 PM
Well...
m

Matt Bernstein

04/21/2022, 1:41 AM
@Alan Fitch Do you usually save all of your queries in netsuite apposed to saving them on your local and versioning them in Git? That's my only wonder about being able to save/edit files I really like y'alls concept of being able to open up multiple queries on a single page, so I made an update to be able to open scratch queries and ones saved in the file cabinet but no saving to the files yet.
a

Alan Fitch

04/21/2022, 1:48 AM
Versioning them in git would be nice but I usually just save them in NS. Maybe something like this? I noticed you don't have autocomplete on the column names. I can help you out with that if you decide to open source it. I think there's no point of 3 of us working on three separate editors. Mine still has an issue with cors and yours is more polished anyway. cc: @Cory Weiner
Good stuff bro
m

michoel

04/26/2022, 12:00 AM
@Matt Bernstein this is fantastic. I'd love to contribute as well. A couple of small suggestions meanwhile: keyboard shortcut (e.g. Ctrl + Enter) to execute. Search box in the results. Export to CSV option. Option to rotate the table 90 degrees (can explain more..)
m

Matt Bernstein

04/26/2022, 2:56 AM
Yes. I will eventually release to be open source and would love to get more help and feedback. There already is a keyboard shortcut(Ctrl/Command + Shift + Enter) to execute and there is also one to format. You can also export as csv if you select the csv format and execute. Intrigued to know the reason for the rotating table 90 degrees
m

michoel

04/26/2022, 3:08 AM
Nice! The use case for rotating the table is I find it makes things so much easier when I'm trying to figure out field names by inspecting sample data. It's a feature I found in SQuirreL SQL. E.g. to figure out what field the "Tax Line" is in SuiteQL, I'd query an existing record and compare the lines. The rotated view makes this a lot easier
3 Views