Document toolboxDocument toolbox

AdHoc Grids

Owned by Brian Dixon
Last updated: Aug 19, 2024
2 min read

AdHoc Grids allow for the creation of data Grids based on a User-Defined SQL query; any AdHoc Grid can be used to generate reports. Knowledge of the SQL language is Required.

For information on how to access a User-Defined Field in an AdHoc Query, please see our article on UDFs.

Creating an AdHoc Grid

When writing your own AdHoc Grid can be a difficult process for an inexperienced User. PCR-360 provides useful tools in both the AdHoc Grid's Query Builder and the Data Dictionary.

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

  2. Click the image-20240819-152050.png  button.

  3. Enter the desired SQL Statement 


  4. Click the image-20240819-152527.png button to run the Query, to confirm the desired output is provided.

  5. Click the image-20240819-152506.png button, on the Saved Queries tab to save the query for use later.

  6. Click the New AdHoc Grid 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 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.

When writing AdHoc grids do not use spaces and other characters in the SQL column Aliases. Using characters other than UPPER-CASE and UNDERSCORE characters, the AdHoc Grid will break and cause any filters to not work.

AdHoc Grid Library

For the convenience of our customers, this Library contains pre-built AdHoc Grids that anyone may copy and add to their PCR-360 application. If you require an AdHoc query not provided by this Library, please contact your Account Manager to request Professional Services; your Account Manager will provide you with a quote to create an AdHoc tailored to your needs.

Using the Library

To load the provided queries into your Organization's instance of PCR-360, simply enter the desired query as your SQL Statement when creating an AdHoc

RECID vs. ROW ID

Library of AdHoc Queries

Cable Locations Report Query







Service Desk Cabling Query







Inventory Reorder Details Report 





Duplicate MAC Address Locator Query





Related Pages