...
Navigate to Admin > AdHoc Grids > Manage Grids.
Click the
button.Enter the desired SQL Statement
Click the
button to run the Query, to confirm the desired output is provided.Click the
button, on the Saved Queries tab to save the query for use later.Click the
button to open the Add New Grid form, which will also move the previously run Query so it is not needed to be re-entered.Provide a Name, Description, as well as any desired Role Permissions and any other customizations to the look of the new Grid.
Click the
Status title Unknown Attachment Save button to save the Grid.
The following functions are not allowed for use: INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, EMPTY, and SELECT INTO.
...