How to create a SQL Script¶
- Step 1
Go to Administration > Setup > Special Content and select the SQL Scripts tab.
- Step 2
Click the green +New SQL Script File button. Enter the suggested name. We recommend using camel casing and no spaces) and Submit.
- Step 3
Copy the script and paste into the Text box of the SQL Script content you just created, and Save SQL Script.
Now you can click Run Script and bookmark the results page for future use.
After running a SQL script or Python script, there will be a link at the bottom of the page titled Add report to menu. This option will allow the user to determine where to display the report in the main menu by Menu, Column, and Header.
After the Menu, Column, and Header designations have been selected for the report, it will show as an option under the chosen place under the main menu.
Note
We also have some SQL reports that you will add to the Custom Reports file in Special Content and they display on the blue Toolbar under Custom Reports. The help documentation for each report will explain where it will appear and direct you to add it to the Custom Report text file when necessary.
Latest Update |
1/15/2024 |
Added info about adding report to menu