Hello, i'm new to SuiteQL, what do I need to do to...
# suiteql
b
Hello, i'm new to SuiteQL, what do I need to do to be able to save the queries? I was told to create a folder in the File Cabinet, then update the "queryFolderID" variable in the SuiteQL Query Tool script with the folder internal ID. The issue is that the only script i find is non-editable. Is there something I'm missing? is there a document somewhere with the instructions? I found somewhere else that i need to need to name the folder "SuiteQL Queries", but this still has not worked. Any help is appreciated 💯
e
I found and updated this file from Customization > Scripting > Scripts
suiteql-query-tool.v2021b2.suitelet.js
Set the folder ID (previously created)
And it worked upon saving a query
b
can't find it here 😞
e
You can visit the module and find the script ID in the URL
b
good idea, will try that
I'm getting this, maybe i'm missing something
thanks for helping
e
Looks like someone imported the module with restrictions
m
You can try another suiteql editor. If you download the shared transactions suiteapp by netgain, navigate to Netgain -> Setup -> SuiteQL Editor Hover “More” in the top right and click “Load SuiteQL File”. It should pull all .sql files in the file cabinet The suiteapp is completely free to use the editor. This is the one we use for all of our development https://www.suiteapp.com/Shared-Transactions-by-Netgain
b
Thanks Matt!! Looks like this one did the trick. Extra thanks for sending the video 🙌