(v1) .AdHoc Grids v2020.3

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.

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, follow the following steps:

1. Navigate to Admin > AdHoc Grids > Manage Grids.
2. Click the  button.
3. The SQL field accepts any valid SQL select statement. Copy the desired query from this Library into this field.
   
   
4. Click the button, on the Saved Queries tab to save the query.

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

RECID vs. ROW ID

The usage of RECID or ROW ID is for clarity about what the RECID or ROW ID represents.

ROW IDs - Row Identification Numbers (ROW IDs) are unique IDs to the row of data in the grid they're assigned to. Some grids do not have a RECID but all grids have ROW IDs.

RECIDs - Record Identification Numbers (RECIDs) are unique IDs for records within a given table. When a grid references a specific record from a table, the Table Name is usually the column name of the RECID that the grid is referencing.

1. IE: SERVICES_RECID in any given grid is referencing the RECID value from the SERVICES Table.
2. Some table names are long and need to be abbreviated to meet the 30 character limit imposed by Oracle Databases.

There are several reasons both are used. 

1. Some grids have multiple RECIDs and a ROW ID is unique to that row of data in the grid.
2. Some grids don’t have a RECID and the ROW ID is unique to that row of data.
3. Some ROW IDs are actually combined RECIDs for two or more records in the row.

Library of AdHoc Queries

Cable Locations Report Query

Service Desk Cabling Query

Inventory Reorder Details Report 

Duplicate MAC Address Locator Query

Related Pages