Page Comparison

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.

...

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 (2024.1) Data Dictionary.

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

2. Click the Image Modified button.

3. Enter the desired SQL Statement 
   Image Modified
   

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

5. Click the

...

1. Image Added

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

2. Click the

   Image Modified

   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.

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

4. Click the

...

1. Status
   title Unknown Attachment

   button to save the Grid.
   

   Image Modified

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

...

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