Page Comparison

...

1. Navigate to Admin > AdHoc Grids > Manage Grids.

2. Click the Image RemovedImage Added  button.

3. Enter the desired SQL Statement 
   
   

4. Click the Image RemovedImage Added button to run the Query, to confirm the desired output is provided.

5. Click the

   Image Removed

   Image Added button, on the Saved Queries tab to save the query for use later.

6. Click the

   Image Removed

   Image Added 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.

7. Provide a Name, Description, as well as any desired Role Permissions and any other customizations to the look of the new Grid.

8. Click the

   Status
   title Unknown Attachment

   Save button to save the Grid.
   

   Image RemovedImage Added

The following functions are not allowed for use: INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, EMPTY, and SELECT INTO.

...