Hey All. I have a general question about how everyone here saves and accesses queries they write for suiteQL. I'm using Tim's suiteQL Query Tool and would like to access my queries in an easy way, such as his "remote library". I see that he's pulling them from AWS. Is anyone doing something similar? It would be nice to same my queries in file cabinet, but i'm up for any solution that makes sense. Thanks!

You can save them to the FileCabinet, then access the queries from the "Local Library" button. I think you need to set the folder internal id in the suitelet to be available.

I usually create queries to be used in scripts. So when I'm done, they are stored in the scripts themselves. However, I also created this https://github.com/watzen/NS-SuiteQL-Reporter if one needs to run a query often.

https://chromewebstore.google.com/detail/suiteadvanced-for-netsuit/eambkjlkacecjilgcdmicbpnhkfhdiee?pli=1 You could also look into getting the SuiteAdvanced plugin. Burkybang (the dev) recently added a way to run SuiteQL in the browser and save commonly used queries amongst hundreds of other features that make using NetSuite better. Bonus: Dark mode

I wrote my own Query Runner tool, and it by default saves your query (in a custom record). You can untick saving it.

wow, interesting comments so far! everyone has a different, yet intriguing solution.

my tool looks like this

Nice Jen!

Each query is it's own custom record instance that is globally searchable. Editing the record allows you to update the query. Viewing the record shows the result of the query.

I really liked that approach Watz (editing and running the query via the same custom record. As opposed to doing something like a custom record for editing, and a suitelet for running)